merging date and time columns in a timetable

10 visualizzazioni (ultimi 30 giorni)
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

Risposta accettata

Walter Roberson
Walter Roberson il 4 Lug 2020
tt = table2timetable( YourTable, 'RowTimes', datetime(YourTable.Date) + duration(YourTable.Time) );

Più risposte (1)

Akram Hussein
Akram Hussein il 4 Lug 2020
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') );

Categorie

Scopri di più su Dates and Time in Help Center e File Exchange

Prodotti


Release

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by