frequency of occurrence of the rows in a table
3 views (last 30 days)
Show older comments
sangeetha r
on 15 Jan 2017
Commented: sangeetha r
on 16 Jan 2017
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?
0 Comments
Accepted Answer
Andrei Bobrov
on 15 Jan 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)')]
More Answers (1)
See Also
Categories
Find more on NaNs 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!