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');

 Akzeptierte Antwort

Walter Roberson
Walter Roberson am 8 Jun. 2022

1 Stimme

Import = table2timetable(Import, 'RowTimes', Import.Name);

Weitere Antworten (0)

Kategorien

Produkte

Version

R2021b

Gefragt:

Pas
am 8 Jun. 2022

Kommentiert:

Pas
am 8 Jun. 2022

Community Treasure Hunt

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

Start Hunting!

Translated by