merging date and time columns in a timetable

조회 수: 10 (최근 30일)
Akram Hussein
Akram Hussein 2020년 7월 4일
답변: 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

채택된 답변

Walter Roberson
Walter Roberson 2020년 7월 4일
tt = table2timetable( YourTable, 'RowTimes', datetime(YourTable.Date) + duration(YourTable.Time) );

추가 답변 (1개)

Akram Hussein
Akram Hussein 2020년 7월 4일
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') );

카테고리

Help CenterFile Exchange에서 Dates and Time에 대해 자세히 알아보기

제품


릴리스

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by