Assign rank to matrix and compare it
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I want to be able to assign a rank to numbers in matrix, let say the matrix has 3 variable random static data. let's say i want to ranked the data from 1 to 5, from top to the bottom (not sort it), For example:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/217569/image.jpeg)
Name = {'Fred';'Betty';'Bob';'George';'Jane'};
Age = [38;43;38;40;38];
Height = [71;69;64;67;64];
Weight = [176;163;131;185;131];
A = table(Age,Height,Weight,'RowNames',Name)
the question:
1.How to assign the rank in the matrix like in the picture above?
2. How to compare the result? let's say i want compare Fred and Bob, i want the final result is Fred because according to the rank order he is rank 1.
Thanks
0 commentaires
Réponse acceptée
KSSV
le 2 Mai 2019
Name = {'Fred';'Betty';'Bob';'George';'Jane'};
Age = [38;43;38;40;38];
Height = [71;69;64;67;64];
Weight = [176;163;131;185;131];
A = table(Age,Height,Weight,'RowNames',Name) ;
Rank = (1:5)' ;
R = table(Rank) ;
T = [A R] ;
idx = min(T.Rank) ;
A(idx,:)
6 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!