How to filter multiple columns with conditions

14 次查看（过去 30 天）

显示更早的评论

Jana Sarran 2023-4-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1939924-how-to-filter-multiple-columns-with-conditions

评论： Peter Perkins 2023-4-5

采纳的回答： Walter Roberson

I am trying to filter column 4 and column 6 of the table below:

I am using the "find" function - DV1 = find((DV.Veh1Type == 630) & (DV.Veh1Type == 640) & (DV.Veh2Type == 640) & (DV.Veh2Type == 630) ) but my cell is a 0×1 empty double column vector.

Can someone assist me with advice on a function that can be used to filter those columns so that only the vehicle type with number 630 and 640 remains in both columns?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson 2023-4-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1939924-how-to-filter-multiple-columns-with-conditions#answer_1207099

在 MATLAB Online 中打开

row_is_selected = ismember(VD.Veh1Type, [630 640]) & ismember(VD.Veh2Type, [630 640]);
subset = DV(row_is_selected, :);

2 个评论
显示无隐藏无

Jana Sarran 2023-4-3

Thank you! This code worked.

Peter Perkins 2023-4-5

In other words, some of those &'s needed to be |'s. Which is what ismember does.

请先登录，再进行评论。

类别

Signal Processing Signal Processing Toolbox Measurements and Feature Extraction Descriptive Statistics

在 Help Center 和 File Exchange 中查找有关 Descriptive Statistics 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by