Effacer les filtres
Effacer les filtres

Converting a table to a timetable

4 vues (au cours des 30 derniers jours)
Isabelle Museck
Isabelle Museck le 15 Mar 2024
Commenté : Voss le 1 Avr 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!

Réponses (1)

Voss
Voss le 15 Mar 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
  1 commentaire
Voss
Voss le 1 Avr 2024
@Isabelle Museck: Did this answer work for you?

Connectez-vous pour commenter.

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by