Transform into a Matlab datetime format, Part 2 (Sample File Attached)

Question

alpedhuez 2018-6-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405734-transform-into-a-matlab-datetime-format-part-2-sample-file-attached

评论： Star Strider 2018-6-15

Test.csv

I have a column of MM_DD_YY and another column with hours (1 to 24). What is the best way to concatenate two entries to apply datetime? Thank you.

2 个评论
显示无隐藏无

dpb 2018-6-14

Again, make it easier for folks to help...supply a short snippet of actual data so

Know precisely how you have it, and
Don't have to make something to hopefully match but can use what is provided directly.

dpb 2018-6-14

Attached file shows why precisely; the TITLE for the date column says MM_DD_YY but that is not how the data are stored; they're mm/dd/yyyy instead so a solution to the original question wouldn't work.

Point being not to criticize but to improve chances of getting correct answers without a lot of back-and-forth by supplying needed info up front. Remember we know only what you tell or show us; we can't see your terminal and we don't know what you've done so far...

请先登录，再进行评论。

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

Answer 1

Star Strider 2018-6-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405734-transform-into-a-matlab-datetime-format-part-2-sample-file-attached#answer_324756

在 MATLAB Online 中打开

Try this:

TestTbl = readtable('Test.csv');
DT = datetime(TestTbl{:,1}, 'InputFormat','MM/dd/yyyy', 'Format','MM/dd/yyyy HH:mm');
DT = DT + hours(TestTbl{:,2}) 
DT = 
    2×1 datetime array
     12/01/2017 01:00
     12/01/2017 02:00