MATLAB: How to sort first column of matrix of numbers by shifting the rows

excelrowssort

I have a 3 column matrix with numerous rows. The data, x,y,z in each row must be preserved. I want to sort the rows in asserding order of x by changing the row position, this is row 5 may become row 1 if x(5) is the minimum. This type of sort is done in EXCEl. What is an equivalent sort in Matlab.

Best Answer

Use sortrows.

Related Solutions

MATLAB: 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

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));

MATLAB: Sort a line of the matrix and change the other lines according the line sorted

Use sortrows.

a = a'; % transpose your matrix
asorted = sortrows(a,1); % sort by first column (row)
asorted = asorted'; % de-transpose your matrix

You can combine all that code into one line:

asorted = sortrows(a')';

Best Answer

Related Solutions

MATLAB: 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

MATLAB: Sort a line of the matrix and change the other lines according the line sorted

Related Question