Ordering of the columns of an array according to a given line

Question

0 个投票

Dear all, I have the following database:

 15    50    15    30    20
 1     3     5     2     4

However, I need to sort as follows:

 15    30    50    20    15
  1     2     3     4     5

Can anyone help me? Thanks a lot. Marcus Vinicius

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

Andrei Bobrov 2012-9-24

编辑：Andrei Bobrov 2012-9-24

1 个投票

A = [15    50    15    30    20
      1     3     5     2     4]; The initial array
[ii ii] = sort(A(2,:));
out = A(:,ii);

or

out = sortrows(A',2)';

Answer 2

Rodrigo 2012-9-24

1 个投票

It seems like you want to sort by the value of the second row. To do this you first find the order you want:

[~,ind]=sort(A(2,:));

where A is the array containing your data. Then you produce the sorted array by calling the index:

B=A(:,ind);