I have a table where each entry is a word/sentence. How do I count how many times a word shows up?

3 views (last 30 days)
I have a table T that is derived from a poll taken online. As an example one column I have 'male', female', 'other' and in another column I have if the prefer 'dog' or 'cat'. My question is how do I count how many times someone answered 'male' and how many times someone answered 'female' etc. So that I can put the results into a pie graph.
gender = [{'male'}; {'female'}; {'male'}; {'male'}]
dogorcat = [{'dog'}; {'cat'}; {'dog'}; {'dog'}]
T = table(gender,dogorcat);

Answers (1)

Ive J
Ive J on 9 Sep 2021
Check out groupsummary:
gender = {'male', 'female', 'male', 'male'}.';
dogorcat = {'dog', 'cat', 'dog', 'dog'}.';
T = table(gender,dogorcat);
genderT = groupsummary(T, 'gender')
genderT = 2×2 table
gender GroupCount __________ __________ {'female'} 1 {'male' } 3

Categories

Find more on Dates and Time 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!