Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 - Make a new dataframe by selecting only columns C ( Plant state abbreviation ) , S ( Unit unadjusted annual SO 2 emissions
Make a new dataframe by selecting only columns C Plant state abbreviation S Unit unadjusted annual SO emissions tons T Unit unadjusted annual CO emissions tons and U Unit unadjusted annual Hg emissions lbs from the sheet UNT
Using the new dataframe, transform the data format to numeric. Remember you need to transform all three numeric columns.
Using the dataset from step Change the column header names as follow: Col Change to State; Col Change to SO; Col Change to CO; Col Change to Hg
Filter the table by removing anything that is not a State name.
Group the data by State
Summarize the SO column by mean.
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