Scripts to extract, transform, and load Los Angeles Yelp data from the Yelp Fusion API and Kaggle. The process takes place in three Jupyter Notebooks, ultimately culminating in our data being persisted in a MySQL / SQLite database.
This was a group project at Washington University's Data Analytics Boot Camp (2019)
- Heather Leek
- Theodore Moreland
- Adam Feldstein
General data cleaning such as standardizing postal codes.
Restaurant Name
Restaurant Address
Restaurant City
Restaurant State
Restaurant Zip
Health Inspection Score
Health Inspection Grade
Business ID
Business Name
Business Address
Business City
Business State
Business Zip
Business ID
Star Rating
Review data
