How to filter multiple columns with conditions
13 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Jana Sarran
el 3 de Abr. de 2023
Comentada: Peter Perkins
el 5 de Abr. de 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 comentarios
Respuesta aceptada
Walter Roberson
el 3 de Abr. de 2023
row_is_selected = ismember(VD.Veh1Type, [630 640]) & ismember(VD.Veh2Type, [630 640]);
subset = DV(row_is_selected, :);
2 comentarios
Peter Perkins
el 5 de Abr. de 2023
In other words, some of those &'s needed to be |'s. Which is what ismember does.
Más respuestas (0)
Ver también
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!