Read date from .CSV in native format of yy-mm-dd
조회 수: 4 (최근 30일)
I am importing data from a .CSV where the native date format is yy-mm-dd. Using functions such as readcell or readmatrix return NaN or Matlab ends up looping because it is having issues with the date format. How can I import this? The formatting of the date is not important, I would just like to have some sort of date stamp for organizational purposes.
Many thanks in advance,
Stephen23 2022년 7월 19일
As far as I can tell, it is not possible to specify the pivot year when calling READTABLE et al. But you can do it afterwards:
T = readtable('test.csv','Format','%s%f')
T.timestamp = datetime(T.timestamp,'inputFormat','yy-MM-dd','PivotYear',2000)