MATLAB: Creating a table in matlab

columnscreaterowstable

Hello everyone,

I have a matrix as shown in the picture. Name of rows are A,B,C,D,E and names of columns are C1,C2,C3,C4,C5,C6 and C7. I want to create a table in matlab.I would like to create a table with the name of the rows and columns in the matrix. How can I do that? Thanks in advance.

Best Answer

Your data must be in a cell. You can do this.

t=cell2table(cell(2));
t.Properties.VariableNames={'c1','c2'}
t.Properties.RowNames={'A','B'}

Related Solutions

MATLAB: How to write this below IF condition in MATLAB

So what exactly do you have? I don't know if you have an array or a table. To get c1,c2,c3, and c4 from a table you do

c1 = t.c1;
c2 = t.c2;
c3 = t.c3;
c4 = t.c4;

To get c1,c2,c3, and c4 from an array you do

c1 = c(:, 1);
c2 = c(:, 2);
c3 = c(:, 3);
c4 = c(:, 4);

Then to do

IF(AND(C1>C2,C1>C3,C1>C4),1,IF(AND(C2>C1,C2>C3,C2>C4),2,IF(AND(C3>C1,C3>C2,C3>C4),3,4)))

you need to specify whether you want that done on a row by row basis , or if all elements (all rows) in something like C1>C2 need to be true. Which is it?

MATLAB: Copy table’s certain data into another table with corresponding variable names

Lets say you want move column Age from table1 to table2

table2.Age=table1.Age

Or if you want to move column 5 to 8 of table1 to table2 do this:

for c=5:8
 table2.(T.Properties.VariableNames{c})=table1.(T.Properties.VariableNames{c});
end

Best Answer

Related Solutions

MATLAB: How to write this below IF condition in MATLAB

MATLAB: Copy table’s certain data into another table with corresponding variable names

Related Question