Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
