Skip to content

Yelp data analysis of business rating, categories, any trends/patterns, correlation, etc.

Notifications You must be signed in to change notification settings

quocduyenanhnguyen/Yelp-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Software I used:

MySQL Workbench: to write SQL

PyCharm: IDE to write Python codes

Data source

Description:

  • I analyzed Yelp data related to business star ratings, review ratings, any trends/patterns, etc. The files are in JSON format so I used Python to parse them before exporting them to CSV files, and then I loaded the files to MySQL database.
  • Attached to this repos is my Python scripts to parse JSON files and load CSV files to database, SQL queries and explanation of output.
  • Link to Tableau viz: https://public.tableau.com/app/profile/anna.quoc.nguyen/viz/Yelpexploratorydashboard/Dashboard1