How to align names with the numbers in a matrix?

2 vues (au cours des 30 derniers jours)
Karanvir singh Sohal
Karanvir singh Sohal le 5 Avr 2021
Modifié(e) : Adam Danz le 6 Avr 2021
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 commentaires
David Fletcher
David Fletcher le 5 Avr 2021
Can't you use a table - using the entries in b as the VariableNames and a as the row data
Karanvir singh Sohal
Karanvir singh Sohal le 5 Avr 2021
Modifié(e) : Karanvir singh Sohal le 5 Avr 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 ......

Connectez-vous pour commenter.

Réponse acceptée

Karanvir singh Sohal
Karanvir singh Sohal le 6 Avr 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 commentaire
Adam Danz
Adam Danz le 6 Avr 2021
Modifié(e) : Adam Danz le 6 Avr 2021
much simpler:
T = array2table(Data,'VariableNames',Name)

Connectez-vous pour commenter.

Plus de réponses (1)

Walter Roberson
Walter Roberson le 5 Avr 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 commentaire
Karanvir singh Sohal
Karanvir singh Sohal le 5 Avr 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?

Connectez-vous pour commenter.

Catégories

En savoir plus sur Resizing and Reshaping Matrices dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by