Hi all. I have imported a large 655x6 data set from excel onto MATLAB and am now trying to extract certain data from the table. The data has a column titled "gender" where male is denoted by a 1 and female by a 0. I want to create two separate arrays: one with all the females, and one with all the males. The arrays need to also contain all additional information in the row associated with each male or female (i.e. their height, ID, FEV, etc.). I sifted through the MathWorks help page about data sets, but I am not too good with syntax. Can anyone help?
This is how the spreadsheet is set up:
ID Height FEV Gender Smoker etc......
1 123 70 63 0 1
2 456 63 102 1 0