Delete unique element in column
Afficher commentaires plus anciens
Hi I have a 25,000,000x2 matrix. I want to delete all Rows which have the same elements in column 1. So I would require only unique elements in column 1 and their corresponding values in column 2.
3 commentaires
Jan
le 29 Juin 2012
Just for clarification:
a = [1,2; 1,3; 3,4] => [3,4] ?
Mate 2u has written as comment to my wrong answer:
Hi Jan for [1,2; 1,3; 3,4] we would expect to see => [1,3; 3,4] as 1 occured more than once (take the last of the non unique values).
This means, that he does not "want to delete all Rows which have the same elements in column 1".
Réponse acceptée
Plus de réponses (1)
Based off of Jan's answer:
A = [1 2; 1 3; 3 4];
[B, I, J] = unique(A(:,1),'last');
NewMatrix = A(I,:);
Catégories
En savoir plus sur Creating and Concatenating Matrices dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!