identify duplicate entries of matrix and delete

4 vues (au cours des 30 derniers jours)
Poulomi Ganguli
Poulomi Ganguli le 13 Oct 2017
Commenté : Star Strider le 14 Oct 2017
Hello,
I have an array as follows. I need to identify duplicate row values from column 1 to 5 and delete the row with negative 7th column element and keep the other row. For example, here row values 5 and 6:
1973 4 1 13 1,34 1,31 0,95 0,35
1973 4 2 2 1,17 1,14 0,85 0,29
1973 4 2 8 -0,5 -0,53 -0,81 0,28
1973 4 2 15 1,54 1,51 1,03 0,48
1973 4 2 18 1,82 1,79 1,03 0,76
1973 4 2 18 1,82 1,79 -0,54 2,33
1973 4 3 3 2,24 2,21 1,02 1,19
1973 4 3 15 1,73 1,70 1,15 0,54
The resulting matrix
1973 4 1 13 1,34 1,31 0,95 0,35
1973 4 2 2 1,17 1,14 0,85 0,29
1973 4 2 8 -0,5 -0,53 -0,81 0,28
1973 4 2 15 1,54 1,51 1,03 0,48
1973 4 2 18 1,82 1,79 1,03 0,76
1973 4 3 3 2,24 2,21 1,02 1,19
1973 4 3 15 1,73 1,70 1,15 0,54
Any help?

Réponse acceptée

Star Strider
Star Strider le 13 Oct 2017
Assigning your matrix to variable ‘M’, this should do what you want:
[~,idx] = unique(M(:,1:5), 'rows', 'stable');
Result = M(idx,:);
  4 commentaires
Poulomi Ganguli
Poulomi Ganguli le 14 Oct 2017
Thanks a bunch!!
Star Strider
Star Strider le 14 Oct 2017
As always, my pleasure!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Shifting and Sorting Matrices 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!

Translated by