Converting a table to a timetable

20 visualizaciones (últimos 30 días)
Isabelle Museck
Isabelle Museck el 15 de Mzo. de 2024
Comentada: Voss el 1 de Abr. de 2024
Hello there I have a table with time in seconds and acclerometer data in the x,y, and z directions. I am trying to convert my table into a time table to perforom analysis but I get an error saying "table2timetable Input table must contain datetime or duration vector for row times", Any suggestions on hiw to fix this or turn my "Time" variable in my table into a datetime or duration vector?
Thank you so much!

Respuestas (1)

Voss
Voss el 15 de Mzo. de 2024
Here's an example:
% a table
T = table([1;2;3],[4;5;6],'VariableNames',{'Time','x'})
T = 3×2 table
Time x ____ _ 1 4 2 5 3 6
% Time column is not duration or datetime
class(T.Time)
ans = 'double'
% try to convert T into a timetable
try
T = table2timetable(T) % error
catch e
disp(sprintf('Error: %s',e.message))
end
Error: Input table must contain datetime or duration vector for row times.
% convert T.Time to durations in seconds
T.Time = seconds(T.Time)
T = 3×2 table
Time x _____ _ 1 sec 4 2 sec 5 3 sec 6
% now Time is duration
class(T.Time)
ans = 'duration'
% and T can be converted into a timetable
T = table2timetable(T)
T = 3×1 timetable
Time x _____ _ 1 sec 4 2 sec 5 3 sec 6

Categorías

Más información sobre Data Type Conversion en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by