rank the values in each row

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

@Qian cao: Please explain why row three is
2 1 2 4
and not
2 1 2 3
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.

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Tags

Asked:

on 4 Feb 2016

Commented:

on 5 Feb 2016

Community Treasure Hunt

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

Start Hunting!