Borrar filtros
Borrar filtros

how to sort the element of one column in a 220*3 matrix in ascending mode, keeping the elements of other columns dependent on the elements of sorted column ?

1 visualización (últimos 30 días)
i have a 220*3 matrix. the elements of first column in this matrix is related to the elements of other 2 columns. how can i sort the elements of first column in ascending mode, moving the elements of other columns correlated to the elements of first column?

Respuesta aceptada

Stephen23
Stephen23 el 20 de Jul. de 2015
Editada: Stephen23 el 20 de Jul. de 2015
If you want to move the entire row based on how the first column is sorted, then use sortrows with its second optional argument (the rows move along with the first column):
sortrows(X,1)
For example:
>> X = [9,1,1,1;1,2,2,2;5,3,3,3]
X =
9 1 1 1
1 2 2 2
5 3 3 3
>> sortrows(X,1)
ans =
1 2 2 2
5 3 3 3
9 1 1 1
If you want to sort only the first column then just use sort and the appropriate indexing (the other columns do not change):
X(:,1) = sort(X(:,1));
  2 comentarios
Joseph
Joseph el 20 de Jul. de 2015
and what if a few elements of first column are the same and i decide to sort with the descending elements of third column?
Stephen23
Stephen23 el 20 de Jul. de 2015
Editada: Stephen23 el 20 de Jul. de 2015
If you had actually read the link to the sortrows documentation that I gave you, then you would already know how: use the second optional argument to do exactly what you want:
sortrows(X,[1,-3])

Iniciar sesión para comentar.

Más respuestas (1)

Jan
Jan el 20 de Jul. de 2015
And this happens inside sortrows:
X = rand(220, 3);
[Y, Order] = sort(X(:, 1));
R = X(Order, :);

Categorías

Más información sobre Shifting and Sorting Matrices en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by