MATLAB: How to assign a variable name to each column of a table composed by only one matrix

variables names table

I have a matrix that I can`t divide in vectors one by one (because it has 130 columns). For exemple, if I have:

A = [1 2 3; 4 5 6;]

I would create a table with different names for each column 1, 2 and 3, like:

        Name1    Name2    Name3   
        _____    _____    _____   
         1         2        3       
         4         5        6

How can I do it? Thanks!

Best Answer

array2table(A, 'VariableNames', {'Name1', 'Name2', 'Name3'})

See the doc

Related Solutions

MATLAB: Merge two tables in matlab

% Creating Table1
T1=table(['A';'B';'C'],[2;5;6],[3;7;8],[4;8;6],'VariableNames',{'SampleName','P1','P2','P3'})
T1 = 
      SampleName    P1    P2    P3
      __________    __    __    __
      A             2     3     4 
      B             5     7     8 
      C             6     8     6 
% Creating Table2  
T2=table(['A';'B';'D'],[1;2;5],[3;5;7],'VariableNames',{'SampleName','P4','P5'})
T2 = 
      SampleName    P4    P5
      __________    __    __
      A             1     3 
      B             2     5 
      D             5     7 
% Joining the two tables  
C=outerjoin(T1,T2,'MergeKeys',1)
C = 
      SampleName    P1     P2     P3     P4     P5 
      __________    ___    ___    ___    ___    ___
      A               2      3      4      1      3
      B               5      7      8      2      5
      C               6      8      6    NaN    NaN
      D             NaN    NaN    NaN      5      7
%Replacing NaN values with zeros
for i=2:size(C,2)
    mask=isnan(table2array(C(:,i)));
    C(mask,i)={0};
end
C = 
      SampleName    P1    P2    P3    P4    P5
      __________    __    __    __    __    __
      A             2     3     4     1     3 
      B             5     7     8     2     5 
      C             6     8     6     0     0 
      D             0     0     0     5     7

MATLAB: How to align multiple matrices based on the first column values

The simplest way is convert your matrices to a table, which may make sense anyway considering that it looks like the columns of your matrices have different meaning. Then simply outerjoin the two tables. e.g:

A = [1,4;2,6;2,7;3,5;3,6;5,2];
B = [2,5;4,6;4,7;5,3];
tA = array2table(A, 'VariableNames', {'Key', 'ValA'});
tB = array2table(B, 'VariableNames', {'Key', 'ValB'});
tC = outerjoin(tA, tB, 'MergeKeys', true)

For multiple tables, repeat the join in a loop.

Best Answer

Related Solutions

MATLAB: Merge two tables in matlab

MATLAB: How to align multiple matrices based on the first column values

Related Question