how to assign rank to each row?

2 views (last 30 days)
Rounak Saha Niloy
Rounak Saha Niloy on 13 Sep 2023
Edited: Stephen23 on 13 Sep 2023
I have a matrix as follows:
A=[1 4;
1 4;
4 1;
4 1;
2 2;
2 3;
2 3;
3 2;
3 3];
I want to have another matrix like this-
B=[1;1;2;2;3;4;4;5;6];
Basically, I want to check each row and increase the corresponding value by 1 if iot does not matches with the preceding one. if it matche with the preceding one, I want to keep it as before.
How can I do this?
  1 Comment
Torsten
Torsten on 13 Sep 2023
Edited: Torsten on 13 Sep 2023
For beginners, a for loop over the rows of A, inside the loop: a comparison of row i with row i-1 and an if-statement that adds 1 to element B(i-1) to get element B(i) if the two rows are not equal and that sets B(i) to B(i-1) if they are equal.

Sign in to comment.

Accepted Answer

Stephen23
Stephen23 on 13 Sep 2023
A = [1,4;1,4;4,1;4,1;2,2;2,3;2,3;3,2;3,3]
A = 9×2
1 4 1 4 4 1 4 1 2 2 2 3 2 3 3 2 3 3
B = cumsum([1;any(diff(A,1,1),2)])
B = 9×1
1 1 2 2 3 4 4 5 6
  2 Comments
Les Beckham
Les Beckham on 13 Sep 2023
Note that diff(A,1,1) is the same as diff(A) so this can be simplified as
A = [1,4;1,4;4,1;4,1;2,2;2,3;2,3;3,2;3,3]
A = 9×2
1 4 1 4 4 1 4 1 2 2 2 3 2 3 3 2 3 3
B = cumsum([1;any(diff(A),2)])
B = 9×1
1 1 2 2 3 4 4 5 6
Stephen23
Stephen23 on 13 Sep 2023
Edited: Stephen23 on 13 Sep 2023
"Note that diff(A,1,1) is the same as diff(A) so this can be simplified as"
Not quite. Consider what happens if one day A happens to have exactly one row... my code still works correctly for any size of matrix A, whereas not specifying the dimension is a latent bug.
For the same reason experienced MATLAB users often prefer to specify the (optional) dimension with many common functions e.g. MAX, MIN, MEAN, etc. when used with non-vector data.

Sign in to comment.

More Answers (0)

Products


Release

R2023a

Community Treasure Hunt

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

Start Hunting!