Assign rank to matrix and compare it
1 view (last 30 days)
Show older comments
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 Comments
Accepted Answer
KSSV
on 2 May 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 Comments
More Answers (0)
See Also
Categories
Find more on Logical in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!