MATLAB Answers

0

How to remove duplicates in matrix with condition

Asked by Berk Gulmez on 6 Oct 2019
Latest activity Commented on by Berk Gulmez on 6 Oct 2019
Hi everyone,
I just want to remove duplicates from NX2 matrices according to greatest value from column 2. for instance lets say we have 5x2 matrices;
X = [1 10;2 20;3 30;3 31;3 32]
at the result ı want to find
Xresult = [1 10;2 20;3 32]
So, I want to eliminate duplicates in "3" values and I want to see greatest "3" value in order to interpret my work.
Regards,

  0 Comments

Sign in to comment.

1 Answer

Answer by Bruno Luong
on 6 Oct 2019
 Accepted Answer

X = [1 10;2 20;3 30;3 31;3 32];
Xs=sortrows(X);
[~,I]=unique(Xs(:,1),'last');
XResult = Xs(I,:)

  1 Comment

thank you! This is exactly what I want.

Sign in to comment.