Convert table into timetable
7 views (last 30 days)
Show older comments
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:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1025020/image.png)
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');
0 Comments
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!