Issues using index to rank rows of a matrix

Hello,

I have the following simple array:

data = [5.35;4.99;4.77;5.13;3.84];

I am trying to use the sort or sortrows function to provide an index or ranking of the rows, such that row 1 would be assigned a '1', row 2 a '3', row 3 a '4', row 4 a '2', and row 5 a '5'.

I am using the following code:

[~,index] = sortrows(data,'descend');

This returns the following ranking, which is incorrect: 1, 4, 2, 3, 5

Is there a solution to get the index output to return the ranking I am seeking?

Thanks,

John

[dpb]

Well, what's the logic behind assigning those indices? They're not based on sorting the input array by value, either ascending nor descending, but some other seemingly more-or-less arbitrary rule.

Can only code what can define first...

[Star Strider]

What criteria are you using to get that ranking? Perhaps I’m missing something, however I don’t see any underlying pattern that would suggest the ranking you want.

Answer 1

[John Harry]

I found the solution to what I needed.

I followed the above with:

[~,index2] = sort(index);

and it returned the ranking I was seeking.

[Star Strider]

I have tto admit that it never occurred to me to sort the sorted indices!

[dpb]

Me, neither! I'm still trying to grasp the meaning of having done... :)

[John Harry]

The data is a small excerpt of athlete performance data. The full data set has 30 rows and 20 columns, where each row represents an individual athlete's performance output and each column is a specific task. I wanted to create a new matrix (or single column for the simplified example I used for the inquiry) that maintains the athletes' row but replaces their performance output with the rank of their performance output across all athletes.

Hopefully that helps explain what the purpose is.

John

[Star Strider]

That might have helped to respond to the original problem.

Since it’s solved now, it is of historical interest only.