merging date and time columns in a timetable

13 visualizaciones (últimos 30 días)
Akram Hussein
Akram Hussein el 4 de Jul. de 2020
Respondida: Akram Hussein el 4 de Jul. de 2020
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

Respuesta aceptada

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

Más respuestas (1)

Akram Hussein
Akram Hussein el 4 de Jul. de 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') );

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Productos


Versión

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by