Getting the frequency of every 'char' value in one field of struct. Can anyone provide code?

The index is the ID of the given movie. The movies array has one struct for every movie in the database:

>> movies(1)
ans =
 struct with fields:
      title: 'Gladiator'
       mpaa: ''
    release: '05/01/2000'
     rating: 8.1000
  votecount: 10921
  countries: 'GB US' %The countries string contains the two-letter country codes separated by a space (if creddited more than one)

prompt: Calculate the number of movies credited to each country. Return a character array of the two letter country abbreviations and a vector of the corresponding number of movies.

[darova]

I'd use strfind to find spaces between words

[Chiwon Oh]

how would I know how many countries there are in that movie array... wouldn't it take too long to go through the each countries field to see how many countries have movies creddited to them?

[darova]

What about for loop?

[Chiwon Oh]

yes, so for i = 1:length(movies). How would I be able to distinguish the every char from another and have each country stored?

[Walter Roberson]

strsplit

[darova]

Maybe something like this?

num = 0;
for i = 1:length(movies)
    str = movies(i).countries;          % extract string
    arr = findstr(str,' ')              % find spaces
    num = num + sum(arr) + 1;    
end

[Chiwon Oh]

that code wouldn't know if it already counted a country in previous iterations

Answer 1

[Ameer Hamza]

try this

movies(1).countries = 'GB US';
movies(2).countries = 'GB CA';
movies(3).countries = 'FR';
movies(4).countries = 'US DE';

countries = {movies.countries};
countries = cellfun(@(x) strsplit(x, ' '), countries, 'UniformOutput', 0);
countries = [countries{:}];
summary = cell2table(tabulate(countries), 'VariableNames', {'country', 'number', 'percent'});

Result:

summary =

  5×3 table

    country    number    percent
    _______    ______    _______

    {'GB'}       2       28.571 
    {'US'}       2       28.571 
    {'CA'}       1       14.286 
    {'FR'}       1       14.286 
    {'DE'}       1       14.286 

[darova]

It's too complicated

[Ameer Hamza]

I guess the OP doesn't just want to know the total number of countries. It appears that The question is about the name of the individual country and the number of movies related to that country.

[Chiwon Oh]

I guess the percentage is just a plus. I have to put the output arguments into a livescript and present it, so the percentage doesn't hurt I don't think.

[Ameer Hamza]

If you don't need percentage than you can add this line at the end

summary.percent = [];

[Chiwon Oh]

thank you!!!

[Ameer Hamza]

Glad to be of help.