Exploratory Community

How to filter out multiple values?


I have a dataframe with 10,000 values, and I only want to filter out a select few.

It looks like this:

I would like to create a table that only shows the values for the following percentiles:

100.0, 99.9, 99.5, 99.0, 95.0, 90.0, 80.0, 70.0, 60.0, 50.0, 40.0, 30.0, 20.0, 10.0

When I plug the first 5 of these values into the filter function, it seems to only return the first 2.

Why is this and what can be done about it?



Hi Stephanie,

Did you try do that using “is in (Multiple Values)” from FILTER instead OR?


Congrats by your questions… always I learn with your doubts and their explanations.

Take care.

1 Like

Hi @Stephanie_Brady

If your goal is to filter using percentile values, you can pass a vector of percentile values to quantile() to get the value at each percentile.

I hope this helps.

1 Like