library(datasets)
library(dplyr)
head(airquality)
filter(airquality, Temp > 70)
filter(airquality, Temp > 80 & Month > 5)
starwars %>%
filter(species == "Droid")
filter(select(flights, UniqueCarrier, DepDelay), DepDelay > 60)
flights %>%
select(UniqueCarrier, DepDelay) %>%
filter(DepDelay > 60)
filter(msleep, sleep_total >= 16, bodywt >= 1)
Multiple Selection Criteria
mydata7 = filter(mydata6, Index %in% c("A", "C"))
AND' Condition in Selection Criteria
mydata8 = filter(mydata6, Index %in% c("A", "C") & Y2002 >= 1300000 )
'OR' Condition in Selection Criteria
mydata9 = filter(mydata6, Index %in% c("A", "C") | Y2002 >= 1300000)
NOT Condition
mydata10 = filter(mydata6, !Index %in% c("A", "C"))
CONTAINS Condition
The grepl function is used to search for pattern matching. In the following code, we are looking for records wherein column state contains 'Ar' in their name.
mydata10 = filter(mydata6, grepl("Ar", State))