colab : Google Cloud Platform

• Video Tutorial on Google Colab

Advantage of using Colab

1. Colab is a google cloud based platform so no need to install any application or software in you computer.
2. Google provide many libraries to work in different areas of Python, we just need to call the required library and staring using them.
3. All your files are hosted in google drive so it is easy to share with others and manage them.
4. Files can be uploaded or downloaded from your local machine or from github.com.
   While uploading or downloading we can convert files to .py or .ipynb or even save as .pdf files.
5. We can easily add TPU (Tensor Processing Unit) , GPU ( Graphics processing Unit) , CPU ( central processing unit ) for our advance study using google platform.

Adding Colab to your drive

New > More > Google Colaboratory 

New > More > Connect More Apps

Version of Python in Colab

!python --version

Adding CSV or Excel files to your code.

1. Upload your CSV or Excel file to any folder in google drive. We created one folder inside our Colab Notbooks folder and named it as downloads. You can give your own name to the folders.
2. Now you have to mount the drive to your colab file. Run this code.

from google.colab import drive
drive.mount('/content/drive')

You will be shown one link and below it there will be an text box asking for authorization code. Visit the link and collect ( copy ) your authorization code. You must be already logged in to your gmail account to get the code.
Paste the code inside textbox and then press enter.
Now your drive is mounted.
3. 
   
   In your left panel you can see drive icon. Expand the directory structure to reach and select your file you want to use. Right click and use copy path.
   Now use this path to create a variable to use in our read_excel() or read_csv() functions.

   import pandas as pd
   path='/content/drive/My Drive/Colab Notebooks/downloads/my_file.xlsx'
   my_data = pd.read_excel(path)

!wget https://raw.githubusercontent.com/adeshpande3/Pandas-Tutorial/master/RegularSeasonCompactResults.csv

Using SQLite in Colab