get all rows from table by more than one categorical

3 次查看(过去 30 天)
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

采纳的回答

nick
nick 2024-8-16
编辑:nick 2024-8-16
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 :
Hope this helps!
  2 个评论
nick
nick 2024-8-16
Glad to know that markus. If you feel that the query has been answered, please feel free to accept the mentioned answer.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Categorical Arrays 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by