Concatenate cells: making column and row headers

Question

Mich 2012-12-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56802-concatenate-cells-making-column-and-row-headers

Hi,

I have a column and a row like this:

   col={'cat1'; 'cat2'; 'cat3'}
   row={'mouse1' 'mouse2' 'mouse3'}

I would like to make these as column and row headers (eventually for a table) like this such that my table looks like this:

I've attempted to use cat such that:

table=cat(2,col,row)

but it results in an error the dimensions are not consistent..

Thank you so much for your help and please let me know if I am not clear.

2 个评论
显示无隐藏无

Azzi Abdelmalek 2012-12-17

Your image is invisible

Mich 2012-12-17

Oh! that is weird, here is the link: http://imgur.com/y0wyb I'm sorry!

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Pedro Villena 2012-12-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56802-concatenate-cells-making-column-and-row-headers#answer_68740

 table(2:numel(row)+1)   = row;
 table(2:numel(col)+1,1) = col;

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Mich 2012-12-17

编辑：Mich 2012-12-17

That's it! The way that gave me the exact result was:

   table(1:numel(row))=row;
   table(1:numel(col),1)=col;

Thank you so much!! And to all the helpers, you are awesome!

请先登录，再进行评论。

Answer 2

Honglei Chen 2012-12-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56802-concatenate-cells-making-column-and-row-headers#answer_68738

table(2:4) = row;
table(2:4,1) = col;

2 个评论
显示无隐藏无

Mich 2012-12-17

Unfortunately i get a dimension mismatch error as well. I tried the method under Azzi's comment because with my real dataset I would not know the if it actually ended on the 4th row. Perhaps I am looking for something more like:

   table={}
   table(2:size(row,2))=row;
   table(2:size(col,1),1)=col;

But I get a dimension mismatch.. Thank you for your response!!

Honglei Chen 2012-12-17

The code below works fine for me. If you get an error, you may need to make sure that your variable, table, is not defined previously with other dimensions. If that still didn't work out, please post your example with the error message.

>> col = {'a','b','c'}
col = 
      'a'    'b'    'c'
>> row = {'d','e','f'}
row = 
      'd'    'e'    'f'
>> table(2:numel(row)+1) = row
table = 
      []    'd'    'e'    'f'
>> table(2:numel(col)+1,1) = col
table = 
       []    'd'    'e'    'f'
      'a'     []     []     []
      'b'     []     []     []
      'c'     []     []     []

请先登录，再进行评论。

Answer 3

Matt Fig 2012-12-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/56802-concatenate-cells-making-column-and-row-headers#answer_68743

编辑：Matt Fig 2012-12-17

row={'cat1'; 'cat2'; 'cat3'};
col={'mouse1' 'mouse2' 'mouse3'};
figure
t = uitable('Data',[],...
            'ColumnName',col,... 
            'RowName',row,...
            'Position',[20 20 360 100])