Counting number of unique elements in a matrix

I have a matrix, 2xT. It contains value PAIRS that are unique and some that are repeated.
I would like to order the matrix by the pairs that occur the most frequently.
myData = randi([0 20], [10000 2]); %make up some data
[C,ia,ic] = unique(myData,'rows');
such that %isequal(C(ic,:), myData) =1. Great.
I now try and work out the ordering
[nOccurances IX] = sort(histc(ic, 1:length(ic)), 'descend');
This gives nOccurances which looks sensible.
Now I try and output:
myDataSorted = myData(ic(IX),:);
The output value is just wrong.
Where have I gone wrong? Thank you!!

2 Comments

SOLVED:
myData = randi([0 20], [10000 2]); %make up some data
[C,ia,ic] = unique(myData,'rows');
[nOccurances IX] = sort(histc(ic, 1:length(ic)), 'descend');
idY = (nOccurances==0);
nOccurances(idY) = [];
IX(idY) = [];
myDataSorted = [nOccurances C(IX,:)];
Then you should either delete the question or submit then Accept your own solution as an Answer

Sign in to comment.

Answers (0)

Asked:

on 10 Jan 2013

Community Treasure Hunt

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

Start Hunting!