Sort a matrix with another matrix

Bi (view profile)

on 16 Oct 2017
Latest activity Commented on by Andrei Bobrov

on 29 Apr 2019

Azzi Abdelmalek (view profile)

How can I sort a matrix A with another matrix B, where the elements of B may be replicated (not in a complete sequence of 1:n with all numbers of 1,2,3,...,n-1,n)? For example,
If I have a matrix A=[5 1; 8 2; 7 3; 3 4; 2 5];
and a matrix of B=[0; 0; 2; 1; 1];
(Or a matrix of B1 where B1=[0 0; 0 0; 2 2; 1 1; 1 1];)
How can I sort A with B with answer of resultant matrix C of C=[5 1; 8 2; 2 5; 3 4; 7 3];?

on 16 Oct 2017

[~,id]=sort(B)
C=A(id,:)

Paul Strickland

Paul Strickland (view profile)

on 27 Jul 2018
What do the ~ and the id represent in this command?
Walter Roberson

on 27 Jul 2018

Andrei Bobrov (view profile)

on 16 Oct 2017

[~,ii] = sortrows([B,A(:,1)])
C = A(ii,:)

Evans Gyan

Evans Gyan (view profile)

on 29 Apr 2019
Under the same problem, I would want to sort or match the vectors in A with that of B.
A = 64.3169
49.8369
54.1163
B = 54.5211
64.1124
50.5202
so that the output will be
C = 64.1124
50.1163
54.5211
Andrei Bobrov

Andrei Bobrov (view profile)

on 29 Apr 2019
[~,i1] = sort(A);
[~,i2] = sort(i1);
Bst = sort(B);
C = Bst(i2);