This is an old revision of the document!
In this lab you will get to know the basics of Python and some of its most useful libraries. After completing this lab, you will be awarded the title of SQL Alchemist.
Ubuntu comes pre-installed with Python 2 and 3. It can also easily be installed using apt-get. However, these are system wide installations that are used by all Python programs. Since Python heavily relies on external libraries, and not all libraries are compatible with all versions of Python, it is often necessary to use different versions of Python for different projects. Thus, the use of Virtual Environments is highly encouraged. Every virtual environment has its own Python distributions and installed libraries. Thus, different projects can be cleanly separated. There are several tools to create and manage virtual environments. In this lab we will use Anaconda.
Follow the link to figure out how to create and activate a new virtual environment. Specify the Python version to be 3.6 and install the following libraries using pip:
The command you need to use is:
conda create --name labEnvironment python=3.6 sqlalchemy sqlite pandas numpy matplotlib
When programming with Python, one has the choice to use IDEs (Integrated Development Enviroments), text editors, an interactive python interpreter or more advanced tools like Jupyter Notebooks. In this lab, we will use the latter.
Let's verify that everything is working.
source activate labEnvironment
conda list
python -V
ipython
print("Something")
If everything is set up correctly, you should see the print statement's output in the terminal.
print("Something Else")
python print.py
If everything is set up correctly, you should see the print statement's output in the terminal.
Now that all is set up, you are ready for the next step.
As mentioned earlier, there are many ways to code Python. In this lab you will be introduced to Jupyter Notebooks. A powerful and convenient method to use Python. All you need to do is open a terminal and navigate to TODO directory where all the contents of this lab are stored. Then, issue following command:
jupyter notebook PythonSQL_Lab.ibynb
This should start the Jupyter Notebook server on Localhost and automatically open a browser window. If the browser is not opened automatically, open one yourself and type the following in the address bar:
http://localhost:8888/notebooks/PythonSQL_Lab.ipynb
For the remainder of this lab, you will be working in the Jupyter Notebook. Just follow the instructions there. Have fun!