Environment Setup

You need jupyter, SQLite, and ipython-sql for doing this assignment. If you have any question, please ask on Piazza.

Install Jupyter Notebook

Jupyter (originally called IPython Notebook) is an open-source web application that allows you to create and share documents that contain live code, equations, visualizations and narrative text. Please install it using Anaconda.

1. Download & install Anaconda for Python 3.9 here
2. Open a terminal and type jupyter notebook to confirm that the installation works

Install SQLite

If you are using Mac OS X or Linux, SQLite should be pre-installed. Open a terminal and type sqlite3. To exit, type .exit

If you are using Windows, please do the followings:

• Step 1 − Go to SQLite download page, and download precompiled binaries from Windows section.

• Step 2 − Download sqlite-shell-win32-.zip and sqlite-dll-win32-.zip zipped files.

• Step 3 − Create a folder C:>sqlite and unzip above two zipped files in this folder, which will give you sqlite3.def, sqlite3.dll and sqlite3.exe files.

• Step 4 − Add C:>sqlite in your PATH environment variable and finally go to the command prompt and issue sqlite3. To exit, type .exit

Install ipython-sql

ipython-sql is a jupyter notebook extension. It allows you to use SQL queries nicely inside jupyter notebooks. You can easily install it using Anaconda.

• Open a terminal and type conda install -c conda-forge ipython-sql