MATLAB Answers

How to align names with the numbers in a matrix?

1 view (last 30 days)
Hello!
I have to put heading row over the data matrix so I used the following code:
a=[12 13 14];
b={'a'; 'b'; 'c';};
c=[char(b)'; num2str(a)]
it gives me:
C= abc
12 13 14
But I want to align the first row over the second one.
required output:
C= a b c
12 13 14
  2 Comments
Karanvir singh Sohal
Karanvir singh Sohal on 5 Apr 2021
This is what I am looking for.
I am confused about how to use it for my case @David Fletcher.
Name={'a' 'b' 'c' 'd' 'e' 'f' 'g' 'h' 'i' 'j' 'k' };
Data=[ 1 2 3 4 5 6 7 8 9 10 11
12 13 14 15 16 17 18 19 20 21 22
23 24 25 26 27 28 29 30 31 32 33];
Name is 1x11 array
Data is 3x11
I can assign variables as
a=Data(:,1)....
but thats a lengthy process and my matrix size can vary.
How can I use table function so that I have "Name" as heading row of table and "Data" matrix as its value.
Required output:
a b c d ......
__________ ______ ______ ______ ______
1 2 3 4 ......
12 13 14 15 ......
23 24 25 26 ......

Sign in to comment.

Accepted Answer

Karanvir singh Sohal
Karanvir singh Sohal on 6 Apr 2021
So, finally I found what I was looking for
Name={'a' 'b' 'c' 'd' 'e' 'f' 'g' 'h' 'i' 'j' 'k' };
Data=[ 1 2 3 4 5 6 7 8 9 10 11; 12 13 14 15 16 17 18 19 20 21 22; 23 24 25 26 27 28 29 30 31 32 33];
T=struct2table(cell2struct(num2cell(Data,1),Name,2));
Thanks :)
  1 Comment
Adam Danz
Adam Danz on 6 Apr 2021
much simpler:
T = array2table(Data,'VariableNames',Name)

Sign in to comment.

More Answers (1)

Walter Roberson
Walter Roberson on 5 Apr 2021
a=[12 13 14];
b={'a'; 'b'; 'c';};
fprintf('%5s %5s %5s\n', b{:}); fprintf('%5d %5d %5d\n', a);
a b c 12 13 14
  1 Comment
Karanvir singh Sohal
Karanvir singh Sohal on 5 Apr 2021
@Walter Roberson If I have huge data this method messes up and made the output hard to read :(.
Is there another method by which "a" and "b" can be included in same array or matrix?

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by