Question: Problem 3: Pivot tables Grading criteria: correctness of code and explanations. 3a. Load the mpg R dataset from the Python statsmodels library into the variable

Problem 3: Pivot tables Grading criteria: correctness of code and explanations. 3a. Load the "mpg" R dataset from the Python statsmodels library into the variable mpg In t J: 3b. Using the pandas pivot_table command, cretae a pandas DataFrame that tells you the average "cty" and "hwy" (city and highway miles per gallon) for each manufacturer In : 3c. Has the average city mileage improved from 1999 to 2008? Has the average highway mileage improved from 1999 to 2008? In [ 1: 3d. Create a scatterplot of pairs (displ, hwy) for all cars in 1999, and another for all cars in 2008. In 1: 3e. What effect does increasing displacement have on highway gas mileage? In [ ]: Problem 3: Pivot tables Grading criteria: correctness of code and explanations. 3a. Load the "mpg" R dataset from the Python statsmodels library into the variable mpg In t J: 3b. Using the pandas pivot_table command, cretae a pandas DataFrame that tells you the average "cty" and "hwy" (city and highway miles per gallon) for each manufacturer In : 3c. Has the average city mileage improved from 1999 to 2008? Has the average highway mileage improved from 1999 to 2008? In [ 1: 3d. Create a scatterplot of pairs (displ, hwy) for all cars in 1999, and another for all cars in 2008. In 1: 3e. What effect does increasing displacement have on highway gas mileage? In [ ]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
