Assignment #1

Due Date: 9am on 1/30

This week's assignment will be broken into two parts:

Part 1: Installing Python

Follow the instructions in this repository for downloading and installing Anaconda locally and creating a new Python environment.

Note: If you are unable to successfully install Python locally, you can also use the Binder link above to proceed with step 2. After loading Binder, a new Jupyter notebook can be created to complete Part 2.

However, local installation is still preferred, so please also contact me any problems encountered.

Part 2: Finding the Philadelphia ZIP Code with the maximum ZHVI over time

If running Python locally, start a Jupyter notebook by running the following command from the command line:

source activate musa
jupyter notebook

This will create the local Jupyter server. If it does not open in a browser, copy the link that is output by the command into your favorite browser. Once the server is running, you can create a new notebook and get started!

The notebook will execute code from the current working directory (the directory that the notebook was launched from). If using relative file paths to load the data, the path should be relative to this working directory. From within the Jupyter notebook, you can find out the current working directory by running the following command in a cell:

pwd

For help running the notebook, see the Jupyter documentation.

Use a Jupyter notebook to find the Philadelphia ZIP code with the largest average annual ZHVI value, for each year in the data set. The Zillow data is available for download in this repository: data/Zip_Zhvi_AllHomes.csv.

The Jupyter notebook should use pandas to load the data and analyze it. The following steps should be followed:

1. Load the ZHVI data for each ZIP code, selecting only Philadelphia ZIP codes.
2. Calculate the annual average ZHVI for each ZIP code in Philadelphia and each year.
3. Identify the ZIP code with the maximum value for each year.

The final result should be the year and the ZIP code with the maximum value.

Submission

Please send your Jupyter notebook .ipynb showing your calculation for Part 2 above.

Files should be submitted to [email protected] by 9am on 1/30.