Yelp-Dataset-Challenge

A data search application for Yelp.com's business review data, using Python and SQL.

Challenge: https://www.yelp.com/dataset

By using this project, you can:

• Search businesses based on state, city, zip code, and category
• Find popular and successful businesses in the area
• Get statistics on businesses in the selected zip code

Project Photo

Project Demo

TBA

How to Use

1. Clone the project:

git clone https://github.com/mollyiverson/Yelp-Database-Challenge.git

2. Install an IDE that can handle Python code such as Visual Studio Code or PyCharm

3. Set up PostgreSQL Database

   • Run MollyIverson_Relations.sql (SQL folder) to create the tables

4. Adjust Postgres username/password in yelpDatabaseProject.py (Application folder), and parseAndInsert.py (Parser folder)

5. Parse the data

   • Run parseAndInsert.py

6. Run Project!

   • Run yelpDatabaseProject.py