Towlie
Towlie

Reputation: 77

How to create / integrate the Yelp Dataset in SQLite (Coursera SQL for Data Science)

I am doing the Coursera course SQL for Data Science. Logically I am a bloody beginner.

For the final assignment you have to analyze the Yelp dataset. However, there is no description on how to obtain the dataset, how to transform it, how to integrate it etc.

If I am downloading the dataset from here: https://www.yelp.com/dataset/download , Which I think is the correct one, I receive a handful of *.json files.

How would I create a SQLite database from this? Or is there somewhere already an SQLite-ready Yelp database to download?

Thanks for your help.

Upvotes: 0

Views: 5709

Answers (1)

Florida Man
Florida Man

Reputation: 2157

You can find the dataset included in the Coursera material within the

Week 4: Reading:Yelp Dataset SQL Lookup (5min)

It is the last of the 4 sections in the Peer Review Assignment panel

Good luck with the assignment

Upvotes: 3

Related Questions