How to count the frequency of each type of column vector present in a matrix

6 views (last 30 days)
I have a matrix R(21,3)
R=[1,1,1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1;1,1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1,1;1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1,1,1];
and I would like to count the frequency of each column vector present from the whole matrix. For instance column vector a=[2,2,2]' is present 3 times, vector b=[2,2,1]' is present 3 times, vector c=[1,4,2]' is present only once. A table with all column vectors and their frequency.

Accepted Answer

David Hill
David Hill on 18 Mar 2021
R=[1,1,1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1;1,1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1,1;1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1,1,1];
a=[2 2 2];
nnz(ismember(R',a,'rows'));
  4 Comments
David Hill
David Hill on 19 Mar 2021
R=[1,1,1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1;1,1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1,1;1,2,2,2,1,2,2,1,4,2,2,2,2,1,2,1,3,1,1,1,1];
[r,idx]=sort(sum(R.*[13;17;19]));%choose primes such that the number of repetitions of each will not exceed
[rr,idx2]=unique(r);
numberOfeachUniqueR=histcounts(r,[rr,r(end)+1]);%generates the number of occurrances of each unique triplet
UniqueR=R(:,idx(idx2));%generates cooresponding unique tripets (just like your output above)

Sign in to comment.

More Answers (0)

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by