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,050 points
24,384 views

2 answers 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,560 points
very cool thanks
0 votes
librarry(dplyr)

dataset >%> filter((a ==1,b>15 ) | (a==2,b>5))
answered Aug 8, 2019 by anonymous

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 Sahiti
• 6,290 points
1,237 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,150 points
388 views
0 votes
1 answer

create data.frame with random numbers in R

First create a matrix with random numbers ...READ MORE

answered Sep 23, 2019 in Data Analytics by Debasmita Das
741 views
0 votes
0 answers

R program: Filter and re-arrange data based on multiple conditions

I have a data in which I ...READ MORE

Jun 30 in Data Analytics by Rajhesh
• 120 points

recategorized Jun 30 by Gitika 55 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
143 views
+1 vote
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,720 points
295 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,720 points
323 views
0 votes
2 answers

How to sort a data frame by columns in R?

You can use dplyr function arrange() like ...READ MORE

answered Aug 21, 2019 in Data Analytics by anonymous
• 32,460 points
328 views
0 votes
10 answers

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

fruit_Frame<-data.frame(Fruit=NA, Cost=NA, Quantity=NA)[-1,]; ...READ MORE

answered May 7 in Data Analytics by yxcv

edited May 8 by Gitika 52,082 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,560 points
934 views