Project Name: EATinerary

Members: Brian and Anna Francesca Gatus

EATinerary project

Linked repos: EATinerary-ETL

Purpose

The purpose of this repo is to take the Yelp Dataset and perform the ETL process for the EATinerary app.

Requirements

1. Python=3.6.8
2. pip
3. PyMySQL==0.9.3
4. pandas==0.24.2
5. numpy==1.16.4
6. SQLAlchemy==1.3.5

Steps

1. Download the Yelp Dataset JSON and place it in the Source data forder
2. Create a config.py in the Eatinerary-ETL folder and include conn=user:pass@host
3. Run either ETL.py or ETL.ipynb
4. Head over to EATinerary app!