MATLAB: Converting all arrays inside a cell to tables

cell arraysMATLABtable

Hello

I have a 40 x 32 cell named C. Each element in C has a dimension of 1 x 1 x 336. I want to keep C as a cell but converting every array in it to a table. In fact, I don't want first and second dimension (1 x 1), I just need 336 values. I want to have these values as a column. I attach C. I would like the output is a cell (40 x 32) with 336 x 1 table inside each cell.

Thank you so much.

Best Answer

newC is 40x32, each cell is a table 336x1 :

newC = cellfun(@(x) table(x(:)), C, 'uniformoutput', false)

Related Solutions

MATLAB: Add columns to the tables that stored in a cell

"I want to add 2 columns in each T, one for latitude and one for longitude."

C2 is a 40x32 cell array of 336x1 tables. Is your goal to create a 40x32 cell array of 336x3 tables where the two additional columns are latitude and longitude values?

If that's what you're doing,

load('C2.mat')  %loads variable C2, a 40x32 cell of 336x1 tables


load('lat.mat') %loads variable lat, a 1x32 table


load('lon.mat') %loads variable lon, a 40x1 table


C2LatLon = cell(size(C2)); 
for i = 1:size(C2,2)            
    for j = 1:size(C2,1)
        n = height(C2{j,i}); 
        C2LatLon{j,i} = [repmat(lon(j,1),n,1), repmat(lat(1,i),n,1), C2{j,i}]; 
        C2LatLon{j,i}.Properties.VariableNames = {'lon','lat','data'};  % do you want to change the var names?
    end
end

The result, C2LatLon is a 40x32 cell array. Each element is a 336x3 table. An example is shown below.

head(C2LatLon{3})  %show first few rows of table #3
ans =
  8×3 table
     lon      lat     data 
    _____    _____    _____
    45.25    24.25     1.08
    45.25    24.25     8.88
    45.25    24.25    25.75
    45.25    24.25    35.46
    45.25    24.25     0.02
    45.25    24.25        0
    45.25    24.25     0.16
    45.25    24.25     0.11

Super table format

However, organizing the tables into a supertable would be more organized and would require less memory.

Here's a variant of Star Strider's deleted answer.

load('C2.mat')  %loads variable C2, a 40x32 cell of 336x1 tables
load('lat.mat') %loads variable lat, a 1x32 table
load('lon.mat') %loads variable lon, a 40x1 table
T = array2table(C2, 'VariableNames',  lat.Properties.VariableNames); 
T = [lat; T]; 
lon = [table(nan,'VariableNames',{'lon'}); lon]; 
T = [lon, T];

Here's a sample of what that looks like

T(1:8,1:6)
ans =
  8×6 table
     lon         lat1             lat2             lat3             lat4             lat5     
    _____    _____________    _____________    _____________    _____________    _____________
      NaN    {[    24.25]}    {[    24.75]}    {[    25.25]}    {[    25.75]}    {[    26.25]}
    44.25    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}
    44.75    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}
    45.25    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}
    45.75    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}
    46.25    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}
    46.75    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}
    47.25    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}    {336×1 table}

Super Table 2 (Recommended)

This arrangement would be easiest to use. Replace row and column names with something more meaningful.

load('C2.mat') %loads variable C2, a 40x32 cell of 336x1 tables
load('lat.mat')%loads variable lat, a 1x32 table
load('lon.mat')%loads variable lon, a 40x1 table
[latMat, lonMat] = ndgrid(lat{:,:}, lon{:,:}); 
C = cellfun(@(T){T{:,:}}, C2); 
LLT = array2table([latMat(:).'; lonMat(:).'], 'RowNames', {'Lat','Lon'}); 
T = [LLT; array2table(cell2mat(C(:)'),'RowNames',compose('Data%d',1:height(C2{1})))];

Here's a sample of the first 8 rows and 10 columns.

T(1:8,1:10)
ans =
  8×10 table
             Var1     Var2     Var3     Var4     Var5     Var6     Var7     Var8     Var9     Var10
             _____    _____    _____    _____    _____    _____    _____    _____    _____    _____
    Lat      24.25    24.75    25.25    25.75    26.25    26.75    27.25    27.75    28.25    28.75
    Lon      44.25    44.25    44.25    44.25    44.25    44.25    44.25    44.25    44.25    44.25
    Data1     1.08     1.06     1.08     0.97     0.96     1.05        1     0.87     0.45        0
    Data2    39.79    20.96     8.88     3.83     3.03     2.55     0.42     0.67     1.46     2.73
    Data3     20.2    23.32    25.75    27.42    30.01    32.44    30.04    28.46    28.27    28.78
    Data4     31.9    34.19    35.46    35.01    32.79    30.68    32.92    31.81    23.53    10.19
    Data5        0        0     0.02     0.19     0.38     0.43     0.43     0.49     0.15        0
    Data6        0        0        0        0        0        0        0     0.01     0.04     0.08

MATLAB: Add specific date time column to every table inside a cell

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);

Best Answer

Related Solutions

MATLAB: Add columns to the tables that stored in a cell

MATLAB: Add specific date time column to every table inside a cell

Related Question