How to remove duplicates in matrix with condition
1 view (last 30 days)
Show older comments
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
Accepted Answer
Bruno Luong
on 6 Oct 2019
X = [1 10;2 20;3 30;3 31;3 32];
Xs=sortrows(X);
[~,I]=unique(Xs(:,1),'last');
XResult = Xs(I,:)
More Answers (0)
See Also
Categories
Find more on Creating and Concatenating Matrices 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!