How to omit milliseconds from a table.
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Constantin
le 6 Nov 2023
Commenté : Constantin
le 6 Nov 2023
Omitting milliseconds when importing datetime.
Hello everyone, I am very new to matlab and writing scripts so please be patient with me.
I am trying to omit the milliseconds from the time I am importing from a CVS file. I came up with the below code to import cvs files based on a naming prefix into a table, but "DatetimeFormate" only changes the displaying of the values not how it is stored.
Ultimately I want to filter out rows from the table with the same HH:mm:ss and join this table with a second one based on the time column. I tried to filter for unique values, or calculating the mean of the values with the same time, but every entry is kept because of the milliseconds being different, so I am looking for a way to omit them.
fSearch=fullfile('TC*'); % build matching wildcard expression
d_TC = dir(fSearch); % and look for match
opts_TC = detectImportOptions(d_TC.name,"VariableNamingRule","preserve"); %Preserving Column Names
opts_TC = setvaropts(opts_TC,"Time","Type","datetime",DatetimeFormat="HH:mm:ss"); %InputFormat="MM/dd/yyyy HH:mm:ss.SSS"
TC = readtable(d_TC.name,opts_TC);
The Resulting table is 90394x6 with the first column being datetime Values like "'11:52:54" and the following five double values for temperatures from a sensor.
Thank you!
0 commentaires
Réponse acceptée
Walter Roberson
le 6 Nov 2023
TC.Time = dateshift(TC.Time, 'start', 'second');
2 commentaires
Les Beckham
le 6 Nov 2023
TC.Time = datetime(2023, 11, 6, 2, 49, 58.8)
TC.TimeTruncated = dateshift(TC.Time, 'start', 'second')
TC.TimeRounded = dateshift(TC.Time, 'start', 'second', 'nearest')
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!