Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions

Question

How do Excel Pivot Tables handle data from non OLAP databases?

Answered: 1 week ago