how to assign rank to each row?

2 visualizaciones (últimos 30 días)
Rounak Saha Niloy
Rounak Saha Niloy el 13 de Sept. de 2023
Editada: Stephen23 el 13 de Sept. de 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 comentario
Torsten
Torsten el 13 de Sept. de 2023
Editada: Torsten el 13 de Sept. de 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.

Iniciar sesión para comentar.

Respuesta aceptada

Stephen23
Stephen23 el 13 de Sept. de 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 comentarios
Les Beckham
Les Beckham el 13 de Sept. de 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 el 13 de Sept. de 2023
Editada: Stephen23 el 13 de Sept. de 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.

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Logical en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by