How to Find Column Duplicates

6 visualizzazioni (ultimi 30 giorni)
RDG
RDG il 25 Giu 2014
Commentato: Jos (10584) il 25 Giu 2014
Suppose:
A{1}=
2 3 1 2
2 1 1 3
2 3 2 4
2 5 2 5
2 6 2 6
2 2 5 2
How can I find the duplicate value and their indices for column 3? Resultant should be: Value: 1,2 Indices: Can be 1,3 --OR-- 1,2,3,4,5.
I tried unique but it returns 5 as well, which is something I don't want.
Gracias.

Risposta accettata

Jos (10584)
Jos (10584) il 25 Giu 2014
X = A{1}
X = X(:,3) % just column 3
[a,i,j] = unique(X) % find all unique elements
n = histc(j,1:numel(a)) % frequency
tf = n > 1 % Which occur more than once?
required result = a(tf) % select those
  2 Commenti
RDG
RDG il 25 Giu 2014
Thanks for the prompt reply. What about the indices of those value? (2nd part of the question)
Jos (10584)
Jos (10584) il 25 Giu 2014
requiredindices = i(tf)

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Special Functions in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by