Convert table into timetable

2 vues (au cours des 30 derniers jours)
Pas
Pas le 8 Juin 2022
Commenté : Pas le 8 Juin 2022
Hello,
I would like to import a .csv file and then convert it into a timetable. The first column of my table wich is called "Name" contains the time in Milliseconds. I tried importing the csv file as table, then converting the time into a duration before converting the table to a timetable.
Unfortunately, I am not able to convert my table.
filename = "PATH";
opts = detectImportOptions(filename);
% Specify range and delimiter
opts.DataLines = [10, Inf];
numVariables = length(opts.VariableNames);
opts.VariableTypes = repmat("double", 1 , numVariables);
% Import the data
Import = readtable(filename, opts,'ReadVariableNames',true);
Import.Name = duration(0,0,0,Import.Name);
%% Clear temporary variables
clear opts filename numVariables
Import = table2timetable(Import,'TimeStep','Name');
My table looks like this:
Error using table2timetable (line 75)
Unable to recognize date/time format of 'Name'. Convert text to datetime or duration.
Error in validierung_einlesen_2 (line 27)
Import = table2timetable(Import,'TimeStep','Name');

Réponse acceptée

Walter Roberson
Walter Roberson le 8 Juin 2022
Import = table2timetable(Import, 'RowTimes', Import.Name);
  1 commentaire
Pas
Pas le 8 Juin 2022
Thank you very much!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Produits


Version

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by