![]() ![]() ![]() In case the notebook is not loading up, try notebook viewer to render it properly. The schema diagram is taken from Dataquest. Other than the libraries and packages listed in file requirements.txt, we also need to use the sqlite interface provided by an in-built python module called sqlite3. The chinook sample database is a good database for practicing with SQL, especially SQLite. ![]() We provide you with the SQLite sample database named chinook. Download pip and install the requirements using pip install -r requirements.txt. Introduction to chinook SQLite sample database.Download Anaconda python distribution, it will install all the libraries needed.There are atleast two ways of getting all the libraries used: This Notebook has been released under the Apache 2.0 open source. You might want to install the listed version or newer of the python libraries. Download the dataset from the above link.Īll the python packages and libraries used in the project are listed in the file requirements.txt.This is necessary for the future SQL lessons in this series. Get into the folder using cd Answering_Business_Questions_using_SQL. Tutorial on how to download SQLite, SQLite Studio, and a Sample Database, Chinook.Installation Getting the Notebook and data We have also included a schema diagram for the Chinook database for reference. This information is contained in eleven tables. The Chinook database contains information about the artists, songs, and albums from the music shop, as well as information on the shop's employees, customers, and the customers purchases. The Chinook database contains information about a fictional digital music shop - kind of like a mini-iTunes store. The dataset we will be using for this project is Chinook database which is provided as a SQLite database file called chinook.db which can be downloaded from here. It involves exploring certain questions which will be interesting for a business to invest in advertising campaigns and generating profit in certain countries. This project is about analyzing data from a database file using SQLite and python. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |