How to filter multiple columns with conditions
4 views (last 30 days)
Show older comments
Jana Sarran
on 3 Apr 2023
Commented: Peter Perkins
on 5 Apr 2023
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 Comments
Accepted Answer
Walter Roberson
on 3 Apr 2023
row_is_selected = ismember(VD.Veh1Type, [630 640]) & ismember(VD.Veh2Type, [630 640]);
subset = DV(row_is_selected, :);
2 Comments
Peter Perkins
on 5 Apr 2023
In other words, some of those &'s needed to be |'s. Which is what ismember does.
More Answers (0)
See Also
Categories
Find more on Multirate Signal Processing in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!