matrix matching w.r.t row

1 view (last 30 days)
sermet OGUTCU
sermet OGUTCU on 21 Jun 2016
Edited: Stephen23 on 21 Jun 2016
matrix_1=
0 0 0 1 2 3
2 0 0 4 5 6
4 0 0 7 8 9
6 0 0 10 11 12
7 59 44 13 14 15
8 59 44 15 16 17
8 0 0 18 19 20
10 0 0 20 21 22
matrix_2=
0 0 0
2 0 0
4 0 0
6 0 0
8 0 0
10 0 0
I need to remove all rows of matrix_1 which don't match matrix_2 rows as follows;
merged_matrix=
0 0 0 1 2 3
2 0 0 4 5 6
4 0 0 7 8 9
6 0 0 10 11 12
8 0 0 18 19 20
10 0 0 20 21 22
[7 59 44;8 59 44]
these parts of the matrix_1 don't matched with the rows of matrix_2. Then they need to be removed as above.

Accepted Answer

Stephen23
Stephen23 on 21 Jun 2016
Edited: Stephen23 on 21 Jun 2016
You can use ismember with the rows option:
>> idx = ismember(matrix_1(:,1:3),matrix_2(:,1:3),'rows');
>> out = matrix_1(idx,:)
out =
0 0 0 1 2 3
2 0 0 4 5 6
4 0 0 7 8 9
6 0 0 10 11 12
8 0 0 18 19 20
10 0 0 20 21 22

More Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!