Find common rows between two matrices with different number of columns

Question

Bassem Mokhtar 2024-1-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2076086-find-common-rows-between-two-matrices-with-different-number-of-columns

评论： Dyuman Joshi 2024-1-30

I have two matrices A and B.

A = [1 2 3; 4 5 6; 7 8 9]
A = 3×3
     1     2     3
     4     5     6
     7     8     9
B = [1 3 20 2; 1 2 3 55; 7 8 9 10; 88 2 1 5]
B = 4×4
     1     3    20     2
     1     2     3    55
     7     8     9    10
    88     2     1     5

and I need to extract the rows in B matrix with common elements in A matrix, row by row.

The result shall be like that:

common_rows = [1 3 20 2; 1 2 3 55; 7 8 9 10]
common_rows = 3×4
     1     3    20     2
     1     2     3    55
     7     8     9    10

Thanks.

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

请先登录，再进行评论。

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

Answer 1

Dyuman Joshi 2024-1-30

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2076086-find-common-rows-between-two-matrices-with-different-number-of-columns#answer_1399606

在 MATLAB Online 中打开

A = [1 2 3; 4 5 6; 7 8 9];
B = [1 3 20 2; 1 2 3 55; 7 8 9 10; 88 2 1 5];
%Indices of rows in B
idx = 1:size(B,1);
for k=idx
    %If elements in a row of B are not common with all elements of any row
    %in A, remove that row index
    if ~any(all(ismember(A, B(k,:)),2))
        idx = setdiff(idx, k);
    end
end
idx
idx = 1×3
     1     2     3
C = B(idx, :)
C = 3×4
     1     3    20     2
     1     2     3    55
     7     8     9    10