How to delete rows from a matrix when the values of certain columns are equal?
2 views (last 30 days)
Show older comments
Vasiliki Charisi
on 15 Oct 2015
Answered: per isakson
on 15 Oct 2015
I have a matrix
M = [1 1 7 8; 2 3 6 9; 5 8 10 8; 4 4 3 1]
and I want to delete the rows that have the same value in the first and second column. In this example I want to delete the rows
1 1 7 8
4 4 3 1
and then have the remaining columns in the matrix:
M = [2 3 6 9; 5 8 10 8]
How do I do that?
0 Comments
Accepted Answer
per isakson
on 15 Oct 2015
Try
>> M = [1 1 7 8; 2 3 6 9; 5 8 10 8; 4 4 3 1]
M =
1 1 7 8
2 3 6 9
5 8 10 8
4 4 3 1
>> M( M(:,1)==M(:,2),:)=[];
>> M
M =
2 3 6 9
5 8 10 8
and look up logical indexing in the Help.
0 Comments
More Answers (0)
See Also
Categories
Find more on Multidimensional 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!