Filtering R data-frame with multiple conditions

Question

a  b
1 30
1 10
1  8
2 10
2 18
2  5

I have this data-set with me, where column 'a' is of factor type with levels '1' and '2'. Column 'b' has random whole numbers. Now, i would want to filter this data-frame such that i only get values more than 15 from 'b' column where 'a=1' and get values greater 5 from 'b' where 'a==2'

So, i would want the output to be like this:

a b
1 30
2 10
2 18

Answer 1

You can use the 'filter' function from 'dplyr' package to solve this:

library(dplyr)
filter(df, (a==1 & b>15) | (a==2 & b>5))

Become a proficient Data Analyst with our comprehensive Data Analyst Course.

Comments

very cool thanks

---

Thank you!!!!

Answer 2

librarry(dplyr)

dataset >%> filter((a ==1,b>15 ) | (a==2,b>5))

Answer 3

Hi,

you can use the with function in R as shown below.

with(df, df[ (x==1 & y>15) | (x==2 & y>5), ])
  x  y
1 1 30
4 2 10
5 2 18

Here you can use all possible conditions.