Question: Use Python to construct a new table based on the given csv and instruction. I'm aware for question 2 I need to use pivot and
Use Python to construct a new table based on the given csv and instruction. I'm aware for question 2 I need to use pivot and elem, but I dont know what should go inside of elem function.



In order to get a better idea of how we can most effectively prevent deaths, we need to first figure out what the major causes of death are. Run the following cell to read in and view the causes_of_death table, which documents the death rate for major causes of deaths over the last century (1900 until 2015) In [91] causes_of_death -Table.read table( 'causes_of_death.csv') causes of death.show (10) Year 2015 2015 2015 2015 2015 Influenza and Pneumonia 2014 2014 2014 2014 2014 Influenza and Pneumonia Cause Age Adjusted Death Rate 168.5 158.5 37.6 43.2 15.2 167 161.2 36.5 40.5 15.1 Heart Disease Cancer Stroke Accidents Heart Disease Cancer Stroke Accidents (570 rows omitted) In order to get a better idea of how we can most effectively prevent deaths, we need to first figure out what the major causes of death are. Run the following cell to read in and view the causes_of_death table, which documents the death rate for major causes of deaths over the last century (1900 until 2015) In [91] causes_of_death -Table.read table( 'causes_of_death.csv') causes of death.show (10) Year 2015 2015 2015 2015 2015 Influenza and Pneumonia 2014 2014 2014 2014 2014 Influenza and Pneumonia Cause Age Adjusted Death Rate 168.5 158.5 37.6 43.2 15.2 167 161.2 36.5 40.5 15.1 Heart Disease Cancer Stroke Accidents Heart Disease Cancer Stroke Accidents (570 rows omitted)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
