q-maze, suozzi-matt, ewp4x
The team was interested in studying housing data for our project and we were able to find census data on affordability ratings of various cities.
The dataset we chose is the US Department of Housing and Urban Development's location affordability index. This dataset combines housing affordability data with transportation costs for all localities within the United States.
There is a dropdown menu to download the Full Dataset in multiple formats. We focused on the spreadsheet format.
Find the final report in the report folder - Final Report
Slides for live presentation - Presentation
All code is in the code folder
The main data exploration can be done with the CS_Semester_Project.ipynb file. Here you can see some of the data cleaning and general analysis of the state data, correlation of specific datafields, and visualizations. This downloads the spreadsheet from the site so loading the data can take time (>200MB).
The user needs to download all the shape files from the data folder and update their path inside the main interactive file called Geopandas_for_User_Output.
Once you have the shape files loaded into a path update this line of code:
