Python with Google Colab + Sheets + Drive
Learn how to use Python to load, adjust, and change data from both Google Sheets and Google Drive using Google Colab.
Colab is a Google version of Jupyter notebooks and offers at lot of great features for free. Learn the basics with this one.
We'll also be using Requests HTML & Pandas to do practical web scraping of BoxOfficeMojo.com.
Lessons
1
Welcome
1:43
2
Sign into Google Drive-
1:26
3
Our First Colab Notebook
3:22
4
A Quick Look at Using Jupyter
2:45
5
Installing Project Requirements
4:21
6
Authenticate with Google Services
3:23
7
A New Spreadsheet with Python and gspread
7:16
8
Google Sheet to Pandas DataFrame
10:12
9
Pandas DataFrame Output to Google Sheet
11:16
10
Mount a Google Drive
4:45
11
Authentication for Drive & Sheets
2:31
12
Authentication for Drive & Sheets Part 2
2:32
13
Saving to and loading from Google Drive
8:35
14
Setup Web Scraping in Colab
5:56
15
Lookup HTML via Python Requests
4:59
16
Parsing the HTML Data with requests-html
18:07
17
Parsed Data to Pandas to CSV in Google Drive
11:38
18
Clean Currency Data
9:32
19
Thank you
1:11