Retrieving Rows based on Multiple Columns

Question

RDG 2013-7-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80957-retrieving-rows-based-on-multiple-columns

Suppose,

var1=[  1  1   3   4   5
        2  14  15  16  17];
var2=  {  1   5   6   7
          3   7   6   5
          4   2   5   9
          2   1   5   7
          5   3   1   6
          15  4   9   1
          18  5   1   3
          17  8   7   4
          16  6   6   3
          14  2   1   2 };

Based on var1(Column 2,3,4,5), I want to retrieve rows in var2 which corresponds to var1 (Column 2,3,4,5)

Desired Result:

3 个评论
显示 1更早的评论隐藏 1更早的评论

RDG 2013-7-3

The previous question was structured wrongly, and since editing it would change the meaning entirely, I decided to start a new thread. Others can make use of that for reference.

Guru 2013-7-3

编辑：Guru 2013-7-3

Ok, this is rather confusing, and maybe I have to refer to the question that Shashank referred.

Your desired results however look like Result{1} should be the rows 1,2,3,5 of var2.

However your var1 columns 2,3,4,5 should be 1,3,4,5. Is this a typo on your part?

Then Result{2} are rows 6,8,9,10 of var2 which really doesn't correspond at all to var1 data...

Please clarify what you are trying to do better.

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2013-7-3

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80957-retrieving-rows-based-on-multiple-columns#answer_90665

编辑：Azzi Abdelmalek 2013-7-3

在 MATLAB Online 中打开

c=cell2mat(var2(:,1));
idx=arrayfun(@(x) find(ismember(c,x))',var1(:,[2 3 4 5]),'un',0)
idx1=arrayfun(@(x) cell2mat(idx(x,:))',[1:size(var1,1)]','un',0)
result=cellfun(@(x) var2(x,:),idx1,'un',0)
result{1}
result{2}