Get startedGet started for free

Filtering and arranging

We're often interested in both filtering and sorting a dataset, to focus on observations of particular interest to you. Here, you'll find counties that are extreme examples of what fraction of the population works in the private sector.

This exercise is part of the course

Data Manipulation with dplyr

View Course

Exercise instructions

  • Filter for counties in the state of Texas that have more than ten thousand people (10000), and sort them in descending order of the percentage of people employed in private work.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

counties_selected <- counties %>%
  select(state, county, population, private_work, public_work, self_employed)

# Filter for Texas and more than 10000 people; sort in descending order of private_work
counties_selected %>%
  # Filter for Texas and more than 10000 people
  ___ %>%
  # Sort in descending order of private_work
  ___
Edit and Run Code