In this assignment, you will be assisting automakers analyze information about cars. Information about various models of cars has been loaded into a $.$csv file. There is also a Word file that will serve as your Data Dictionary and has a brief description of each column. You have to click on the "Study Unit $3$ Homework" link in order to see the two files.

Note: If you are using Google colab, see the instructions on importing in the "Resources" folder in Brightspace.

Using either Anaconda$/$Jupyter or Google Colab, develop Python code that will accomplish the following:

First, load the $.$csv file into a pandas data frame and show the code in a code block. $(1\mathrm{.}5$ points$)$

Also in a code block, show the code to determine the car with the highest horsepower $($the column is hp$),$ then add a comment block to indicate which car. $(1\mathrm{.}5$ points$)$

In a code block, show the code to determine the car with the lowest mileage $($the column is mpg$),$ then add a comment block to indicate which car. $(1\mathrm{.}5$ points$)$

In a code block, show the code which will sort the data frame by the mpg$,$ from highest to lowest. $(1\mathrm{.}5$ points$)$

In a code block, show the code which will show the mean and median mpg$,$ then add a comment block to show the answers. $(1\mathrm{.}5$ points$)$

Add a comment block which shows each column except the model name, and whether the column is nominal, ordinal or numeric. $(2\mathrm{.}5$ points$)$

Make sure your notebook name includes your last name, and then submit it$.$ Note that only files with the suffix $.$ipynb will be accepted