frequency of occurrence of the rows in a table

3 visualizzazioni (ultimi 30 giorni)
I am attempting to count the number of times each row occurred in a table. i have the table( 5 row, 2 column)
a=
'b2' 'YE'
'b2' 'YE'
'b5' 'HN'
'b5' 'HN'
'b6' 'NV'
I want to get the output
b=
'b2' 'YE' 2
'b5' 'HN' 2
'b6' 'NV' 1
Is there anyway to solve this?

Risposta accettata

Andrei Bobrov
Andrei Bobrov il 15 Gen 2017
a = {'b2' 'YE'
'b2' 'YE'
'b5' 'HN'
'b5' 'HN'
'b6' 'NV'};
[a1,~,c] = unique(a,'stable');
cc = reshape(c,size(a));
[n,~,c1] = unique(cc,'rows','stable');
out = [a1(n),num2cell(histcounts(c1,1:max(c1)+1)')]

Più risposte (1)

Image Analyst
Image Analyst il 15 Gen 2017
Check out unique() with the 'rows' option.

Community Treasure Hunt

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

Start Hunting!

Translated by