Assign rank to matrix and compare it
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Paulus Soenarjo
am 2 Mai 2019
Kommentiert: Paulus Soenarjo
am 5 Mai 2019
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 Kommentare
Akzeptierte Antwort
KSSV
am 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!