To do the ETL (Extract, Transform and Load) of the data needed to run an application for Houston Real Estate Investment Dashboard.

• Source: https://texasschoolguide.org/school-rankings/
• Download: CSV file

• Source: http://nationalflooddata.com/flood/floodapi/
• Web request API using street addresses from HCAD dataset

• Source: https://pdata.hcad.org/download/2019
• Download: ZIP folders comprised of text files and csv files

• Source: https://www.houstontx.gov/police/cs/Monthly_Crime_Data_by_Street_and_Police_Beat.htm
• Download: CSV file

Files location: https://drive.google.com/drive/folders/15sKnJGCKU_VsG290i97kzsAnyc1tFNNT

1. Extract and Transform HCAD Data: ETL_HCAD.IPYNB
2. Extract and Transform Flood and Crime Data: ETl_flood_and_crime_data.IPYNB
3. Extract and Transform School Data: school_data_transformation.IPYNB, school_zone_transformation.IPYNB
4. Load Real Estate Database: ETL_Project_Load.IPYNB, Houston_Real_Estate_db.sql