Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 1 . Collapse data. a . Import the dataset ukcpr _ national _ welfare _ data.csv . Keep the following variables state _ name,
Problem Collapse data.
a Import the dataset ukcprnationalwelfaredata.csv Keep the following variables statename, statefips, year, Population, Employment, Unemploymentrate, and GrossStateProduct, and then subset the dataframe to Finally, keep only five states: Georgia, Florida, North Carolina, South Carolina, and Virginia.
b Following part a create employmenttopopulation ratio employmentpopulation and GDP per capita Gross state productpopulation Find the state with the highest average GDP per capita between Hint: use the groupby function
Problem Basic plots.
Using the dataframe you created in part a of problem 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
b A line graph that shows the evolution of unemployment rates in Georgia between
c Modify the line graph in part and add the lines for the other four states.
d Use the facetwrap funciton to produce a graph that has a separate subplot for each state.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started