Only keep rows of a table that that belong to certain subject names (specified in first collumn of row)

Hi all,

I have my data stored in the form of a table where the first collumn contains the subject names ('subject_1', 'subject_2' etc.) and the following collumns contain the data from all the variables.

Unfortunately I'll have to exclude some of the participants (rows) due to data quality issues and I have a list of all the subjects that I want to keep saved in a separate table that contains all subject names (subjects names only) that I want to keep in the 'Main table'. Somehow, I want to find a way to 'match ' the two tables.

Thanks a lot!

Johanna

[Stephen23]

The solution will most likely involve: https://www.mathworks.com/help/matlab/ref/ismember.html

"Only keep rows of a cell array that... I have my data stored in the form of a table..."

So whch do you actually have: a table or a cell array? Tables are not cell arrays:

https://www.mathworks.com/help/matlab/tables.html

https://www.mathworks.com/help/matlab/cell-arrays.html

[Johanna Popp]

Sorry my bad - I am working with tables.

[Johanna Popp]

However - the ismember function works for me. Thanks a lot!