Selecting a county from each region
Previously, you used the walk
column, which offers a percentage of people in each county that walk to work, to add a new column and count to find the total number of people who walk to work in each county.
Now, you're interested in finding the county within each region with the highest percentage of citizens who walk to work.
counties_selected <- counties %>%
select(region, state, county, metro, population, walk)
This exercise is part of the course
Data Manipulation with dplyr
Exercise instructions
- Find the county in each region with the highest percentage of citizens who walk to work.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
counties_selected %>%
# Group by region
___
# Find the county with the highest percentage of people who walk to work
___