How to filter multiple columns with conditions

13 visualizaciones (últimos 30 días)
Jana Sarran
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?

Respuesta aceptada

Walter Roberson
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
Jana Sarran
Jana Sarran el 3 de Abr. de 2023
Thank you! This code worked.
Peter Perkins
Peter Perkins el 5 de Abr. de 2023
In other words, some of those &'s needed to be |'s. Which is what ismember does.

Iniciar sesión para comentar.

Más respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by