get all rows from table by more than one categorical

Hi All,

I want to filter my table and get subtables for statistical calcs.

I use the commant:

D=table

D_sub=D(D.LogID== '2',:);

To get all rows with the LogID 2. How can I expand this commant to get for example all data from LogID 2,3,4 and 5 with one commant?

Than you

Markus

Answer 1

[nick]

Hi Markus,

You can retreive get all data for various LogID values with a single command using the function 'ismember', as shown below:

% Define the LogID values you want to filter
logIDsToFilter = {'2', '3', '4', '5'};

% Use ismember to filter the table
D_sub = D(ismember(D.LogID, logIDsToFilter), :);

This command filters the table D to include only the rows where LogID matches any of the specified values. You can refer to the following documentation to learn more about 'ismember' function :

https://www.mathworks.com/help/matlab/ref/double.ismember.html

Hope this helps!

[markus tripolt]

Thank you Neelanshu!

Thats exactly what I needed :)

[nick]

Glad to know that markus. If you feel that the query has been answered, please feel free to accept the mentioned answer.