Add specific date time column to every table inside a cell

3 views (last 30 days)
BN on 10 Feb 2020
Commented: Luna on 10 Feb 2020
Hey all, Here is my cell:
I want to add a date-time column for each table. In fact, my date time column is just date.mat. I attached C too. So in the output, I would like a 40 x 32 cell (just like this C), with 336 x 4 tables inside it. I would like to have a date in the front existing column in each table.
Thank you.

Accepted Answer

Luna on 10 Feb 2020
Edited: Luna on 10 Feb 2020
Easiest and fastest way to do it using a cellfun and converting them to a timetable. Here is one line to do it all:
NewCellArray = cellfun(@(x) table2timetable(x,'RowTimes',date),C2LatLon,'uni',false);
Or if you don't want a timetable just a table with a date column you can use below:
NewCellArray2 = cellfun(@(x) addvars(x,date,'Before','lon') ,C2LatLon,'uni',false);

More Answers (0)




Community Treasure Hunt

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

Start Hunting!