Calculating the number of government employees
In the video, you used the unemployment variable, which is a percentage, to calculate the number of unemployed people in each county. In this exercise, you'll do the same with another percentage variable: public_work.
The code provided already selects the state, county, population, and public_work columns.
This exercise is part of the course
Data Manipulation with dplyr
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
counties_selected <- counties %>%
select(state, county, population, public_work)
counties_selected %>%
# Add a new column public_workers with the number of people employed in public work
___