Table of Contents
- Course information
- Python 2.7 installation
- Anaconda installation
- Launching Jupyterlab
- Video Tutorial
1 Course Information
- Pandas is an open-source library and a python module that is used for data analysis, data manipulation, and data visualization purposes. It works well with relational data as well as with unlabeled data.
- In this course, we are going to cover how to pre-process the data, load the data for visualization and reporting purposes. The course is mainly designed for people who think coding is difficult. Hence, it’s going to be helpful. We will discuss everything related to the SQL side and Python side. A basic understanding of Python is needed such as Python data types, dictionaries, tuples, etc. We are going to cover all the practicals using the Jupyterlab.
- Jupyterlab should be installed beneath Anaconda. Hence, we should install python first in order to install Anaconda. So, we are first going to install Python, then Anaconda and finally we are going to launch Jupyter Notebook.
2 Python 2.7 Installation
First, we are going to download Python 2.7 from the Python website as shown in figure 1. Select Python 2.7.15 from the list.
Then select 32-bit or 64-bit according to your OS. Here, we are going to select 64-bit and give a few minutes, it to be downloaded. This is shown in figure 2
After Python 2.7 is downloaded, click on it. Make sure to give admin privileges in order to get full access as shown in figure 3.
- Then select, Install for all users. Then click next, after giving the destination folder click, next.
- Then let it be installed into your PC. At the completion of the installation, click finish, as shown in figure 4.
You can verify whether if it’s installed by clicking the windows button. As shown in figure 5, if it’s installed you can see the Python IDLE(GUI) and the Python command line (CLI).
You can launch any of the one to see the Python version which is installed. Next, we have to install Anaconda.
Secondly, we are going to download the Anaconda setup from the Anaconda website. Once you are going to download it, it will be asking for two versions; Python 3.6 or Python 2.7. Select the version for Python 2.7 as we downloaded it before. This is shown in figure 6.
- After the setup file is downloaded, double click on it, and it will prompt you to “run” window. Click next.
- Select your preference, whether you want it to install for all users or for only you. Here, we selected “just me”, as shown in figure 7.
For advanced options, select “Add Anaconda to the system PATH environment variable”, then click install as shown in figure 8. Give a few minutes to let it be installed into your PC.
After been installed, click next and then click finish as shown in figure 9(the given two options, you can select or ignore).
In order to launch Anaconda, go to start, search for Anaconda navigator, and select it as shown in figure 11. Meanwhile, search for the Anaconda prompt and select it as well.
To see the list of packages downloaded to Anaconda, type “conda list” in Anaconda prompt and press enter
shown in figure 11. It will list out the packages as shown in figure 12. As you can see, the Pandas is also downloaded.
Launching the Jupyterlab
In the Anaconda Navigator window, you can see the Jupyterlab icon. Click the launch button as shown in figure 13
Then it will ask you, where do you want to open it. Select your preference, in here, as you can see in figure 14, we selected Google Chrome.
Once you selected it and click ok, it will prompt you to a Google Chrome window (with the localhost). As you can see in figure 15, on the left-hand side it shows the files you want to import. If you don’t want to see this go to view, and then untick “show left area”.
select the Python 2 file under Notebook as shown in figure 16. You will be prompt into the notebook, which is shown in figure 17, where you will code and do the practicals in this course.