Exploratory Community

How to filter out multiple values?

#1

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?

Thanks!

#2

Hi Stephanie,

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

image.

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

Take care.

1 Like
#3

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