Assign rank to matrix and compare it

1 次查看（过去 30 天）

Paulus Soenarjo 2019-5-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459730-assign-rank-to-matrix-and-compare-it

评论： Paulus Soenarjo 2019-5-5

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:

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

KSSV 2019-5-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/459730-assign-rank-to-matrix-and-compare-it#answer_373214

在 MATLAB Online 中打开

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,:)