How do I organize a table using a specified cell array?
    3 views (last 30 days)
  
       Show older comments
    
    Aryan Cross
 on 12 Nov 2020
  
    
    
    
    
    Commented: Star Strider
      
      
 on 12 Nov 2020
            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. 
0 Comments
Accepted Answer
  Star Strider
      
      
 on 12 Nov 2020
        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.  
2 Comments
More Answers (0)
See Also
Categories
				Find more on Tables 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!
