get all rows from table by more than one categorical
1 次查看(过去 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
0 个评论
采纳的回答
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
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 Center 和 File Exchange 中查找有关 Categorical Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!