You can use the following basic syntax with the %in% operator in R to filter for rows that contain a value in a list:
library(dplyr) #specify team names to keep team_names <- c('Mavs', 'Pacers', 'Nets') #select all rows where team is in list of team names to keep df_new <- df %>% filter(team %in% team_names)
This particular syntax filters a data frame to only keep the rows where the value in the team column is equal to one of the three values in the team_names vector that we specified.
The following example shows how to use this syntax in practice.
Example: Using %in% to Filter for Rows with Value in List
Suppose we have the following data frame in R that contains information about various basketball teams:
#create data frame
df <- data.frame(team=c('Mavs', 'Pacers', 'Mavs', 'Celtics', 'Nets', 'Pacers'),
points=c(104, 110, 134, 125, 114, 124),
assists=c(22, 30, 35, 35, 20, 27))
#view data frame
df
team points assists
1 Mavs 104 22
2 Pacers 110 30
3 Mavs 134 35
4 Celtics 125 35
5 Nets 114 20
6 Pacers 124 27
Suppose we would like to filter the data frame to only contain rows where the value in the team column is equal to one of the following team names:
- Mavs
- Pacers
- Nets
We can use the following syntax with the %in% operator to do so:
library(dplyr) #specify team names to keep team_names <- c('Mavs', 'Pacers', 'Nets') #select all rows where team is in list of team names to keep df_new <- df %>% filter(team %in% team_names) #view updated data frame df_new team points assists 1 Mavs 104 22 2 Pacers 110 30 3 Mavs 134 35 4 Nets 114 20 5 Pacers 124 27
Notice that only the rows with a value of Mavs, Pacers or Nets in the team column are kept.
If you would like to filter for rows where the team name is not in a list of team names, simply add an exclamation point (!) in front of the column name:
library(dplyr) #specify team names to not keep team_names <- c('Mavs', 'Pacers', 'Nets') #select all rows where team is not in list of team names to keep df_new <- df %>% filter(!team %in% team_names) #view updated data frame df_new team points assists 1 Celtics 125 35
Notice that only the rows with a value not equal to Mavs, Pacers or Nets in the team column are kept.
Note: You can find the complete documentation for the filter function in dplyr here.
Additional Resources
The following tutorials explain how to perform other common operations in dplyr:
How to Select the First Row by Group Using dplyr
How to Filter by Multiple Conditions Using dplyr
How to Filter Rows that Contain a Certain String Using dplyr
