In addition to subsetting a data frame by columns, you can also subset a data frame by rows using dplyr’s filter() function and comparison operators! Consider an orders data frame that contains data related to the orders for an e-commerce shoe company:

Let’s say you want to find all orders made by customers with the first name 'Joyce'.

orders %>%
  filter(first_name == 'Joyce')

• the orders data frame is piped into filter()
• the condition first_name == 'Joyce' is given as an argument
• a new data frame containing only the rows where first_name == 'Joyce' is returned

What if you have multiple conditions you want to be met? Not a problem! To find all orders made of faux-leather AND costing more than 25:

orders %>%
  filter(shoe_material == 'faux-leather',price > 25)

• the orders data frame is again piped into filter()
• the conditions shoe_material == 'faux-leather' and price > 25 are given as arguments
• a new data frame containing only the rows where both conditions were met is returned

You can provide any number of conditions that you please, as long as you separate each condition by a comma as its own argument. Note: each condition that you list must be met for a row to be returned!