Search code examples
sqldatabasesqliteyelp

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.

Solution

  • 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