I have a CSV file with date and time values I want to import and convert to datetime

Question

Tim Moriarty 2016-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277291-i-have-a-csv-file-with-date-and-time-values-i-want-to-import-and-convert-to-datetime

评论： dpb 2016-4-5

The import tool will not convert this to Datetime and I have tried many different options all of which will not allow me to convert the dates in this CSV file to datetime. Example of the format of the dates in the CSV file: {'1/1/2015 1:00:00 AM'} The format of the data is Month/Day/Year Hour:Min:Second AM or PM There are no "0"s infront of any of the month or day values. I have tried MM/DD/YYYY and many different versions of this format

Code that does not work:

DateStrings = importfile(:,'DateTime');
  t = datetime(DateStrings,'InputFormat','M/d/y h:MM:SS a');

The clock values are a 12 hour clock as they start at just a date value and then the next value has the hour data and the AM/PM. Any help would be greatly appreciated!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2016-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277291-i-have-a-csv-file-with-date-and-time-values-i-want-to-import-and-convert-to-datetime#answer_216536

在 MATLAB Online 中打开

Use

t = datetime(DateStrings,'InputFormat','M/d/y h:mm:ss a');

instead. 'MM' --> Months and 'SS' --> fractional seconds fields. See <datetime-properties Format>

2 个评论
显示无隐藏无

Tim Moriarty 2016-4-5

I used your code and this still comes up Error using datetime (line 613) Input data must be a numeric or a cell array or char matrix containing date/time strings. It is in a table as text '1/1/2015 1:00:00 AM'

dpb 2016-4-5

Well, you didn't say that...extract the table column into a cell array or string array as instructed.

请先登录，再进行评论。

Answer 2

Kuifeng 2016-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277291-i-have-a-csv-file-with-date-and-time-values-i-want-to-import-and-convert-to-datetime#answer_216539

在 MATLAB Online 中打开

 %After you have the strings of DateStrings, try the following
formatOut = 'dd mmm yyyy HH:MM:SS AM';
t=datestr(datenum(DateStrings,'dd/mm/yyyy HH:MM:SS',1900),formatOut)