Filtering R data-frame with multiple conditions

0 votes
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
Mar 26, 2018 in Data Analytics by coldcode
• 2,010 points
3,921 views

1 answer to this question.

0 votes

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

library(dplyr)
filter(df, (a==1 & b>15) | (a==2 & b>5))
answered Mar 26, 2018 by Bharani
• 4,550 points
very cool thanks

Related Questions In Data Analytics

0 votes
1 answer

How to order data frame rows according to vector with specific order using R?

You can try using match: data <- data.frame(alphabets=letters[1:4], ...READ MORE

answered Apr 30, 2018 in Data Analytics by darklord
• 6,140 points
49 views
0 votes
1 answer

How to filter a data frame with dplyr and tidy evaluation in R?

Requires the use of map_df to run each model, ...READ MORE

answered May 16, 2018 in Data Analytics by DataKing99
• 8,100 points
61 views
0 votes
0 answers

create data.frame with random numbers in R

Hi, How to create data.frame object in ...READ MORE

Jul 9 in Data Analytics by nishanth
13 views
0 votes
1 answer

Big Data transformations with R

Dear Koushik, Hope you are doing great. You can ...READ MORE

answered Dec 17, 2017 in Data Analytics by Sudhir
• 1,610 points
35 views
0 votes
1 answer

How to convert a list of vectors with various length into a Data.Frame?

We can easily use this command as.data.frame(lapply(d1, "length< ...READ MORE

answered Apr 4, 2018 in Data Analytics by DeepCoder786
• 1,700 points
47 views
0 votes
1 answer

How to spilt a column of a data frame into multiple columns

it is easily achievable by using "stringr" ...READ MORE

answered Apr 9, 2018 in Data Analytics by DeepCoder786
• 1,700 points
54 views
0 votes
1 answer

How to sort a data frame by columns in R?

You can just use the order function ...READ MORE

answered Apr 10, 2018 in Data Analytics by darklord
• 6,140 points
74 views
0 votes
1 answer

How to convert a list to data frame in R?

Let's assume your list of lists is ...READ MORE

answered Apr 12, 2018 in Data Analytics by nirvana
• 3,060 points

edited Apr 12, 2018 by nirvana 1,879 views
0 votes
8 answers

Creating an empty data.frame with only column names - R

Please try following code snippet. df <- data.frame(matrix(ncol ...READ MORE

answered Mar 7 in Data Analytics by RajkumarManiRaja
8,501 views
0 votes
1 answer

Converting R data-frame to h2o object

All you have to do is run ...READ MORE

answered Apr 2, 2018 in Data Analytics by Bharani
• 4,550 points
464 views