SQLforDataScienceProject

Profiling and Analyzing the Yelp Dataset Coursera Worksheet

First part:

A series of questions are answered to profile and understand.

Second part:

Inferences and analysis of the data for a particular research question.

For both parts of this assignment, use this the "worksheet" is provided online. Dataset (Yelp Dataset Worksheet) and codes are on Jupyter Notebook (the codes and answers are uploaded in three formats (text, pdf, docx) on the respiratory).

Language:

SQLite

Learning outcomes:

• Posing more reviews does not necessarily correlate with more fans
• There is not a strong correlation between having a high number of fans and being listed as "useful" or "funny
• There is a strong correlation between the location of the business and their rating
• There is not a strong correlation between the number of likes and stars in the reviews