rank the values in each row

2 views (last 30 days)
Qian cao
Qian cao on 4 Feb 2016
Commented: Qian cao on 5 Feb 2016
Hi all, If I have a matrix like
A=
0.2 NaN 0.8 0.8
-0.2 1 0.3 0.2
0.2 -0.3 0.2 2
0.7 -0.1 -0.4 0.7
NaN 0.2 NaN 0.9
How do I get a resulting matrix B which ranks each row of A and the result shows like this ... Pay attention to row 3. Thank you for your answer.I am playing around some tricks in Matlab and looking for a best solution to problems as this one...
B=
1 NaN 2 2
1 4 3 2
2 1 2 4
3 2 1 3
NaN 1 NaN 2
  2 Comments
Stephen23
Stephen23 on 5 Feb 2016
Edited: Stephen23 on 5 Feb 2016
@Qian cao: Please explain why row three is
2 1 2 4
and not
2 1 2 3
Qian cao
Qian cao on 5 Feb 2016
Hi, This is an exercise given by our teacher. He said when there are 2 equal values, the rank of the next value larger than them will be +2 instead of +1.

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 4 Feb 2016
Loop through the rows. For any one row, you can use the third output of unique as the index, except that you would have to replace the entries corresponding to NaN.
  1 Comment
Stephen23
Stephen23 on 4 Feb 2016
Edited: Stephen23 on 4 Feb 2016
Using uniquetol to do this would be more robust.

Sign in to comment.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!