MATLAB Answers

How to convert time in nanosecond to numeric value in order to be able to compare these timeseries?

8 views (last 30 days)
Mantas Vaitonis
Mantas Vaitonis on 15 Nov 2018
Edited: madhan ravi on 16 Nov 2018
Hello,
I have the number of *.csv files that are same structure (same column number), but row numbers are different. I use readtable to upload data to matlab. I need to compare timeseries of different csv files. The example of timeseries:
'08:34:37.762296992'
'08:34:37.762450580'
'08:34:37.762450580'
'08:34:37.762460422'
'08:34:37.762460422'
'08:34:37.762472108'
'08:34:37.762472108'
'08:34:37.762543205'
'08:34:37.762543205'
'08:34:37.762673812'
How to convert this type to timeseries to numeric value in order to be able to compare them?

  0 Comments

Sign in to comment.

Accepted Answer

madhan ravi
madhan ravi on 15 Nov 2018
Edited: madhan ravi on 16 Nov 2018
T=readtable('mycsv.csv')
datetime(T{:,1},'InputFormat','HH:mm:ss.SSS') %highly recommended

  11 Comments

Show 8 older comments
Peter Perkins
Peter Perkins on 15 Nov 2018
Also: these two
datenum(T{:,1})
datevec(T{:,1})
aren't really gonna work correctly, because datenums and datevecs just don't support timestamps to ns resolution.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by