How to Find Column Duplicates

11 Ansichten (letzte 30 Tage)
RDG
RDG am 25 Jun. 2014
Kommentiert: Jos (10584) am 25 Jun. 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.

Akzeptierte Antwort

Jos (10584)
Jos (10584) am 25 Jun. 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 Kommentare
RDG
RDG am 25 Jun. 2014
Thanks for the prompt reply. What about the indices of those value? (2nd part of the question)
Jos (10584)
Jos (10584) am 25 Jun. 2014
requiredindices = i(tf)

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Community Treasure Hunt

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

Start Hunting!

Translated by