How do I organize a table using a specified cell array?

1 view (last 30 days)
In the example found in this documentation, how would I index the data by Gender? Such as if I wanted a new table selecting only rows with {'Male' } or {'Female'}?
I am wondering if it is different than:
rows = (T.Smoker==true & T.Age<40);
T(rows,:)
as it is a cell. Thank you.

Accepted Answer

Star Strider
Star Strider on 12 Nov 2020
One approach is to use the findgroups function:
load patients
T = table(Age,Gender,Height,Weight,Smoker,...
'RowNames',LastName);
[Grp,ID] = findgroups(T.Gender);
Males = T(Grp==2,:);
The ‘ID’ variable indicates that these are sorted lexiically, so 1=Female, and 2=Male.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!