How to check and update one matrix by comparing the element of another matrix?

Question

suchismita 2015-4-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/209672-how-to-check-and-update-one-matrix-by-comparing-the-element-of-another-matrix

评论： suchismita 2015-4-17

I have a matrix 10*3

   2     3
   2     4
   2     5
   3     4
   3     5
   4     5
   3     4
   3     5
   4     5
   4     5
now i want to check whether second and third column pairs are existing in another 10 by 2 matrix or not

example:

   2
   3
   4
   5
   3
   4
   5
   4
   5
   5
and if any pair from 10 by 3 matrix is not able to satisfy the condition will be removed.

for example:

in first row 1 2 3 -- 2 3 is available in 10*2 matrix so will keep that row as it is but if this condition is not satisfied, the entire row will be removed from 10*3 matrix

please please help me.

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2015-4-17

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/209672-how-to-check-and-update-one-matrix-by-comparing-the-element-of-another-matrix#answer_175654

编辑：Guillaume 2015-4-17

在 MATLAB Online 中打开

Use ismember with the 'rows' option:

A = [1 2 3; 1 2 4; 1 2 5; 1 3 4; 1 3 5; 1 4 5; 2 3 4; 2 3 5; 2 4 5; 3 4 5];
B = [1 2; 2 3; 4 5]; %reduced second matrix so some rows of A are missing
isrowpresent = ismember(A(:, [2 3]), B, 'rows');
A(~isrowpresent, :) = [] %delete rows not present