merging date and time columns in a timetable

Question

Akram Hussein 2020-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/559301-merging-date-and-time-columns-in-a-timetable

回答： Akram Hussein 2020-7-4

I have .csv file with two separate columns one for date and one for time. I am trying to import them both in a single field in a timetable and use them as rowtimes. Any pointers?

Date Time

____ ______

06/07/2020 17:00:01

06/07/2020 17:00:02

06/07/2020 17:00:03

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/559301-merging-date-and-time-columns-in-a-timetable#answer_460835

在 MATLAB Online 中打开

tt = table2timetable( YourTable, 'RowTimes', datetime(YourTable.Date) + duration(YourTable.Time) );

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

请先登录，再进行评论。

Answer 2

Akram Hussein 2020-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/559301-merging-date-and-time-columns-in-a-timetable#answer_461012

Thank You. I had to do just a tweak in formatting to make it work. So posting the code for others. The time format i was using was 'MM/dd/yyyy HH:mm:ss' and had to be specified. Further t.Date is of type datetime and t.Time is of type duration

t = readtable(filename);

tt = table2timetable( t, 'RowTimes', datetime(t.Date + t.Time,'Format','MM/dd/yyyy HH:mm:ss') );