How do I sort the rows in one array based on the row order of another array?

1 次查看（过去 30 天）
Brad
Brad 2015-11-9
评论： Brad 2015-11-10
I have 2 matrices;
C is 7 x 3 double and G is a 9 x 3 double;
C = [1 1 0; 1 0 1; 0 1 1; 1 0 0; 0 1 0; 0 0 1; 0 0 0];
G = [0 1 1; 0 0 0; 1 0 0; 1 0 1; 0 0 1; 0 0 0; 0 1 1; 1 0 0; 1 0 0];
I’m attempting to create a subset of C (New_C), based on the contents of G, where the order of the rows appearing in New_C are identical to those in C. The proper output would be as follows;
New_C = [ 1 0 1; 0 1 1; 1 0 0; 0 0 1; 0 0 0];
I am able to attain the unique rows in G with the following;
New_C = unique(G, ‘rows’);
But the rows are not in their proper order.
Is there a way to re-order/sort the rows in New_C such that their order matches the rows in C ?
Thanks you.

请先登录，再回答此问题。

采纳的回答

James Tursa
James Tursa 2015-11-9
Try this (Caution, untested since I am not on a machine with MATLAB at the moment):
[~,Locb] = ismember(New_C,C,'rows');
New_C = C(sort(Locb),:);
Assumes all rows of New_C can be found in C.
  1 个评论
Brad
Brad 2015-11-10
James, thanks for the push!
I had to make a mod and add some code, but it works:
% Find the subset of C
[~,Locb] = ismember(G,C,'rows');
New_C = C(sort(Locb),:);
% Get the unique values and sort
[~,idx]=unique(New_C,'rows');
out=New_C(sort(idx),:);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by