Add specific date time column to every table inside a cell

1 view (last 30 days)
Hey all, Here is my cell:
Capture.JPG
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
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)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2018b

Community Treasure Hunt

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

Start Hunting!