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 ?

4 vues (au cours des 30 derniers jours)
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?

Réponse acceptée

Stephen23
Stephen23 le 20 Juil 2015
Modifié(e) : Stephen23 le 20 Juil 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 commentaires
Joseph
Joseph le 20 Juil 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 le 20 Juil 2015
Modifié(e) : Stephen23 le 20 Juil 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])

Connectez-vous pour commenter.

Plus de réponses (1)

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

Catégories

En savoir plus sur Shifting and Sorting Matrices dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by