Assign rank to matrix and compare it
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
KSSV
2019 年 5 月 2 日
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 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Logical についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!