Getting unique values of an excel sheet relying on one column only.
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Please, I have an excel file with many rows and five columns. I need to remove the duplicated data of all columns considering the uniqueness of the last column only.
For example:( x,y,z,p,f) are columns
x y z p f
1 2 3 4 5
1 3 5 6 4
2 3 5 7 4
3 4 1 5 4
the result should be
1 2 3 4 5
1 3 5 6 4
Many thanks for help.
0 commentaires
Réponse acceptée
Andrei Bobrov
le 4 Sep 2016
z = [1 2 3 4 5
1 3 5 6 4
2 3 5 7 4
3 4 1 5 4];
[~,b] = unique(z(:,end),'stable');
out = z(b,:);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!