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 commentaires

Stephen23
Stephen23 le 5 Fév 2016
Modifié(e) : Stephen23 le 5 Fév 2016
@Qian cao: Please explain why row three is
2 1 2 4
and not
2 1 2 3
Qian cao
Qian cao le 5 Fév 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.

Connectez-vous pour commenter.

Réponses (1)

Walter Roberson
Walter Roberson le 4 Fév 2016

0 votes

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 commentaire

Stephen23
Stephen23 le 4 Fév 2016
Modifié(e) : Stephen23 le 4 Fév 2016
Using uniquetol to do this would be more robust.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Mathematics and Optimization dans Centre d'aide et File Exchange

Tags

Question posée :

le 4 Fév 2016

Commenté :

le 5 Fév 2016

Community Treasure Hunt

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

Start Hunting!

Translated by