Filter löschen
Filter löschen

frequency of occurrence of the rows in a table

1 Ansicht (letzte 30 Tage)
sangeetha r
sangeetha r am 15 Jan. 2017
Kommentiert: sangeetha r am 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?

Akzeptierte Antwort

Andrei Bobrov
Andrei Bobrov am 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)')]
  1 Kommentar
sangeetha r
sangeetha r am 16 Jan. 2017
Thank you so much Andrei Bobrov. That solved my problem.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Image Analyst
Image Analyst am 15 Jan. 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