From matrix to timetable

6 views (last 30 days)
Rub Ron
Rub Ron on 14 Aug 2019
Commented: Steven Lord on 14 Aug 2019
I have a matrix bb (class:double), where the first column is the time in numeric format. I want to convert this matrix to a timetable:
I can do it with this line:
zz=array2timetable(bb(:,2:end),'RowTimes',datetime(bb(:,1)','ConvertFrom','excel'))
But to me does not look optimal as I have to do it for several long matrices inside an array. Is there a better way to do so?

Accepted Answer

Neuropragmatist
Neuropragmatist on 14 Aug 2019
I think what you have there is about as efficient as you can get.
M.
  1 Comment
Steven Lord
Steven Lord on 14 Aug 2019
One minor optimization, to reduce typing, would be to make that into a function or an anonymous function. That would at least save you having to retype the parameters to array2timetable repeatedly.
makeTT = @(x) array2timetable(x(:, 2:end), ...
'RowTimes', x(:, 1), ...
'ConvertFrom', 'excel');
y1 = makeTT(x1);
y2 = makeTT(x2);
% etc

Sign in to comment.

More Answers (0)

Categories

Find more on Data Type Conversion in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!