how to delete rows with some repeated elements?

Question

Iris Li 2018-5-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/403179-how-to-delete-rows-with-some-repeated-elements

评论： Iris Li 2018-5-31

for example I need to delete one out of two rows whose numbers in column 1&2 are the same. At the same time the deleted row should have a smaller number in column 3. I know the unique command but don't know how to use in this situation. Thanks in advance. I have a=[1,2,3; 1,2,4; 5,6,7; 5,6,8];I want to get b=[1,2,4;5,6,8]

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2018-5-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/403179-how-to-delete-rows-with-some-repeated-elements#answer_322478

编辑：Stephen23 2018-5-30

在 MATLAB Online 中打开

One way using sortrows and unique:

>> a = [1,2,3;1,2,4;5,6,7;5,6,8];
>> b = sortrows(a,3);
>> [~,idx] = unique(b(:,1:2),'rows','last');
>> b = b(idx,:)
b =
   1   2   4
   5   6   8

The sortrows call sorts rows by the third column (i.e. smaller values come before larger), then we select the unique rows (only columns 1 & 2), taking the last one each time (which because the rows are sorted will be the larger value in the third column).