Filter Rows Based on Conditions in a DataFrame in R
In this article, we will explore various methods to filter rows based on Conditions in a data frame by using the R Programming Language.
How to filter rows based on Conditions in a data frame
R language offers various methods to filter rows based on Conditions in a data frame. By using these methods provided by R, it is possible to filter rows. Some of the methods to filter rows based on conditions are:
Filter rows based on a single condition
This method is used to filter rows based on a single condition. In the below example, we created a data frame and filtered rows based on a single condition.
df <- data.frame( name=c("a","b","c","d","e","f"),
id=c(100,250,300,450,500,600),
age=c(10,20,30,35,40,50)
)
print(df)
res <- df[df$id > 400, ]
print("The resultant data frame is")
print(res)
Output:
name id age
1 a 100 10
2 b 250 20
3 c 300 30
4 d 450 35
5 e 500 40
6 f 600 50
[1] "The resultant data frame is"
name id age
4 d 450 35
5 e 500 40
6 f 600 50
In the below example, we created a data frame and filtered rows based on a single condition.
df <- data.frame( name=c("a","b","c","d","e","f"),
id=c(100,250,300,450,500,600),
age=c(10,20,30,35,40,50)
)
print(df)
res <- df[df$age > 35, ]
print("The resultant data frame is")
print(res)
Output:
name id age
1 a 100 10
2 b 250 20
3 c 300 30
4 d 450 35
5 e 500 40
6 f 600 50
[1] "The resultant data frame is"
name id age
5 e 500 40
6 f 600 50
Filter rows based on Multiple conditions
These method is used to filter the rows based on multiple conditions. In the below example, we created a data frame and filtered rows based on multiple conditions.
df <- data.frame( name=c("a","b","c","d","e","f"),
id=c(100,250,300,450,500,600),
age=c(10,20,30,35,40,50)
)
print(df)
res <- df[df$age > 30 & df$id == 450, ]
print("The resultant data frame is")
print(res)
Output:
name id age
1 a 100 10
2 b 250 20
3 c 300 30
4 d 450 35
5 e 500 40
6 f 600 50
[1] "The resultant data frame is"
name id age
4 d 450 35
In the below example, we created a data frame and filtered rows based on multiple conditions.
df <- data.frame( name=c("a","b","c","d","e","f"),
id=c(100,250,300,450,500,600),
age=c(10,20,30,35,40,50)
)
print(df)
res <- df[df$name %in% c("b", "e"), ]
print("The resultant data frame is")
print(res)
Output:
name id age
1 a 100 10
2 b 250 20
3 c 300 30
4 d 450 35
5 e 500 40
6 f 600 50
[1] "The resultant data frame is"
name id age
2 b 250 20
5 e 500 40
Conclusion
In conclusion, we learned about how to filter rows based on conditions in a data frame. R programming language offers versatile tools while handling to filter rows based on conditions in a data frame.
Contact Us