I am trying to execute following codes :
rows={'A','B'};
data = cell(0,5);
T = cell2table(data);
T.Properties.RowNames = rows;
Matlab is throwing an error :The RowNames property must contain one name for each row in the table.
Can anybody comment if I am missing anything? I will appreciate any help.

 Réponse acceptée

Aravind Ravikumar
Aravind Ravikumar le 21 Juin 2019

0 votes

Hey, cell(0,5) returns a 0x5 empty cell array. That is why row number isn't matching with rows variable. You should use You can simply create a cell array using the command,
data = {0,5}
Also, in this example data is a 1x2 cell array. Hence it has only one row. To change that row name, you could do something like,
rows={'A'};
data = {0,5};
T = cell2table(data);
T.Properties.RowNames = rows;
For creating a 2x1 cell array, you'll have to use
rows={'A','B'};
data = {0;5};
T = cell2table(data);
T.Properties.RowNames = rows;

5 commentaires

Rajeev Kumar
Rajeev Kumar le 3 Juil 2019
Thanks very much for correcting the code. However I have stuck in one implementation where I want to create a table with just column and row name. I am trying in the following way
Step1 : tab1 = cell2table(...) ; tab2=cell2table(...) ;tab3=cell2table(...)
Step2 : table = [tab1 tab2 tab3]
step3 : table..Properties.RowNames = x_name ; x_name is a cell array of specied element (say it is of size 1x20)
This is throwing the following error : The RowNames property must contain one name for each row in the table. Can I create a table with only rows and column name?
Walter Roberson
Walter Roberson le 3 Juil 2019
No. You must have at least one column of value along with the row name, and that column must have as many rows as you have row names.
Walter Roberson
Walter Roberson le 3 Juil 2019
Further testing shows that to be incorrect: You can have rownames even with now columns.
What is showing up as size(table) ?
Rajeev Kumar
Rajeev Kumar le 4 Juil 2019
Thanks Walte size. Here is the result:
size(table)=0x3
h=table.Properties.VariableNames
h =
1×3 cell array
{'tab1'} {'t'ab2} {'tab3'}
Could you please comment on this?
Walter Roberson
Walter Roberson le 4 Juil 2019
With 0 rows you must have 0 row names.

Connectez-vous pour commenter.

Plus de réponses (1)

Akshay Malav
Akshay Malav le 21 Juin 2019
Modifié(e) : Akshay Malav le 21 Juin 2019

0 votes

First change the number of rows from 0 to 1 and correspondingly the rows array should contain only 1 element either 'A' or 'B'. Run it , it will work fine
Here is the code
rows={'A'};
data = cell(1,5);
T = cell2table(data);
T.Properties.RowNames = rows;

1 commentaire

Walter Roberson
Walter Roberson le 21 Juin 2019
Right. You can only have a row name for a row that exists. You cannot put in placeholder row names for rows to be added later.

Connectez-vous pour commenter.

Catégories

Community Treasure Hunt

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

Start Hunting!

Translated by