Exploratory Community

How can I filter a certain value without dropping NA?

#1

When you filter a certain value from a column that has NA,

it filters out not only the one you specify but also NA.

But sometimes, you want to keep the NA while filtering out the one you specify. In such case, you can add another filter condition with ‘Is not NA’.

And the filter rule to ‘OR’ instead of the default ‘AND’.

This will keep the NA while filtering out the one you specify.