Delete unique element in column

2 visualizzazioni (ultimi 30 giorni)
Mate 2u
Mate 2u il 29 Giu 2012
Modificato: Miguel L il 27 Dic 2015
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 Commenti
Jan
Jan il 29 Giu 2012
Modificato: Jan il 29 Giu 2012
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".
Miguel L
Miguel L il 27 Dic 2015
Modificato: Miguel L il 27 Dic 2015
¡Hello Jan!
Regarding to this question, actually I wanna get "a = [1,2; 1,3; 3,4] => [3,4] ", as you suggest at first ¿Could you help me? Tank you in advance.

Accedi per commentare.

Risposta accettata

Jan
Jan il 29 Giu 2012
What about:
unique(x, 'rows')
?
  1 Commento
Ryan
Ryan il 29 Giu 2012
A = [1 2; 1 3; 3 4];
unique(A,'rows')
ans =
1 2
1 3
2 4

Accedi per commentare.

Più risposte (1)

Ryan
Ryan il 29 Giu 2012
Modificato: Ryan il 29 Giu 2012
Based off of Jan's answer:
A = [1 2; 1 3; 3 4];
[B, I, J] = unique(A(:,1),'last');
NewMatrix = A(I,:);

Tag

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by