Convert table into timetable

2 views (last 30 days)
Pas
Pas on 8 Jun 2022
Commented: Pas on 8 Jun 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');

Accepted Answer

Walter Roberson
Walter Roberson on 8 Jun 2022
Import = table2timetable(Import, 'RowTimes', Import.Name);

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!