Question: Problem 1 . Collapse data. a . Import the dataset ukcpr _ national _ welfare _ data.csv . Keep the following variables state _ name,

Problem 1. Collapse data.
a. Import the dataset ukcpr_national_welfare_data.csv. Keep the following variables state_name, state_fips, year, Population, Employment, Unemploymentrate, and GrossStateProduct, and then subset the dataframe to 2010-2019. Finally, keep only five states: Georgia, Florida, North Carolina, South Carolina, and Virginia.
b. Following part a, create employment-to-population ratio (employment/population) and GDP per capita (Gross state product/population). Find the state with the highest average GDP per capita between 2010-2019(Hint: use the group_by() function).
Problem 2. Basic plots.
Using the dataframe you created in part a of problem 1 above, create the following plots (make sure that everything is properly labeled):
a. A bar chart that compares the population across the five states between in 2019.
b. A line graph that shows the evolution of unemployment rates in Georgia between 2000-2019.
c. Modify the line graph in part c and add the lines for the other four states.
d. Use the facet_wrap() funciton to produce a graph that has a separate subplot for each state.
 Problem 1. Collapse data. a. Import the dataset ukcpr_national_welfare_data.csv. Keep the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!