# Filtering DataFrame based on two conditions

**URL:** <https://discourse.julialang.org/t/filtering-dataframe-based-on-two-conditions/89248>\
**Category:** General Usage\
**Tags:** dataframes\
**Created:** [October 25, 2022, 1:15pm UTC](https://discourse.julialang.org/t/filtering-dataframe-based-on-two-conditions/89248 "2022-10-25T13:15:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mb96](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mb96/32/45786_2.png) [@mb96](https://discourse.julialang.org/u/mb96)\
**Post date:** [October 25, 2022, 1:15pm UTC](https://discourse.julialang.org/t/filtering-dataframe-based-on-two-conditions/89248/1 "2022-10-25T13:15:06Z")

</div>

Hi everyone,

I am trying to filter a dataset based on two conditions but it does not allow me to do so unless I write an auxiliary function which in my case is now worth it.

Is there not a way to do the following in a simple way?

```julia
filter(:AGE31X => a -> a .== 46 && :percentile_label_Platinum => R -> R .== 35, data)

```

thanks a lot!

---

<div class="post-metadata">

**Author:** ![bkamins](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bkamins/32/208538_2.png) [@bkamins](https://discourse.julialang.org/u/bkamins)\
**Post date:** [October 25, 2022, 1:23pm UTC](https://discourse.julialang.org/t/filtering-dataframe-based-on-two-conditions/89248/2 "2022-10-25T13:23:19Z")

</div>

Use:

```julia
subset(data, :AGE31X => a -> a .== 46, :percentile_label_Platinum => R -> R .== 35)

```

or

```julia
filter([:AGE31X, :percentile_label_Platinum] => (a, R) -> a == 46 && R == 35, data)

```

or with DataFramesMeta.jl:

```julia
@rsubset(data, :AGE31X == 46, :percentile_label_Platinum == 35)

```