How to delete rows from a matrix when the values of certain columns are equal?
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
per isakson
2015-10-15
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Multidimensional Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!