counting frequency of strings

10 次查看(过去 30 天)
huehuehue
huehuehue 2013-3-22
Hi I have a very large variable containing 3 letter country codes (GBR, CHN, USA, etc) and i think some of them repeat, so what is the best way to find the frequency of every country in that variable?
Thanks PS: variable size is 100 x 3 (100 countries)

回答(1 个)

Azzi Abdelmalek
Azzi Abdelmalek 2013-3-22
编辑:Azzi Abdelmalek 2013-3-22
x=strvcat('USA','ALG','FRA','ALG','FRA');
y=unique(x,'rows');
for k=1:size(y,1)
freq(k)=sum(ismember(x,y(k,:),'rows'));
end
out=[cellstr(y) num2cell(freq')]
If your data is a cell array
x={'USA';'ALG';'FRA';'ALG';'FRA'};
y=unique(x);
for k=1:numel(y)
freq(k)=sum(strcmp(x,y(k)));
end
out=[y num2cell(freq')]
  2 个评论
huehuehue
huehuehue 2013-3-23
exactly what I wanted, thanks!
Cedric
Cedric 2013-3-23
编辑:Cedric 2013-3-23
Don't forget to [ Accept ] the answer.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Programming 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by