This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Automate Your Life With Python
installation and Setup
Important Note (+Cheat Sheet for The Course)
Install Python and Pycharm (4:48)
Python Crash Course (Optional)
Section Overview
Installing Python and Jupyter Notebook through Anaconda (3:24)
Jupyter Notebook Interface (10:00)
Cell Types and Modes in Jupyter Notebook (7:35)
Hello World (3:49)
Data Types (8:37)
Variables (7:41)
Lists (24:18)
Dictionary (10:34)
If Statement (6:12)
For loop (5:42)
Function (7:08)
Modules (3:40)
File and Folder Operation
OS vs Path Module (7:56)
Creating Folders and Subfolders (10:57)
Rename Folders and Files & Get Path of All Subdirectories (14:54)
Exercise 1 - Rename file based on parent and grandparent folders (14:02)
Exercise 2 - Change Extension of a file (6:22)
Create and Delete Files (6:12)
Extract Zip (3:24)
Search File (5:52)
Web Automation & Web Scraping: Automate Morning News
Section Overview
HTML Basics - Tags and Elements (7:49)
HTML Basics - Tree Structure (3:52)
XPath - Syntax, Functions and Operators (3:41)
XPath - Test Your XPath (5:29)
XPath - Special Characters and Syntax (4:37)
Installing Selenium and ChromeDriver (2:19)
Automate The News - Creating The Driver (4:10)
Automate The News - Finding Elements (19:45)
Automate The News - Exporting Data to a CSV File (7:58)
Automate The News - Headless mode (5:42)
Automate The News - Preparing Script to Be Run Everyday (11:56)
Convert py to exe (6:59)
Schedule Python Script with crontab (masOS) (5:03)
Note: Schedule a Python Script on Windows
Schedule Python Script with Task Scheduler (Windows) (3:26)
Project 1: WhatsApp
Section Overview
Basic Automation with pywhatkit - Sending Messages to Contacts and Groups (10:00)
Automate WhatsApp with Selenium - Sending Messages (25:09)
Automate WhatsApp with Selenium - Sending a Photo (22:21)
Automate WhatsApp with Selenium - Connect Selenium to an Existing Browser (8:50)
Automate WhatsApp with Selenium - Adding Waits (13:02)
Automate a "Good Morning" message - Preparing Script to Be Run Everyday (19:42)
Schedule Python Script with crontab (macOS) (3:00)
Note: Schedule a Python Script on Windows
Project 2: Tinder
Section Overview
Important Note (Updates)
Automating Tinder - Building The XPaths (24:50)
Automating Tinder - Adding a For Loop, Try/Excepts and Waits (12:09)
Connect Selenium to an Existing Browser (5:19)
Schedule Python Script (2:33)
Regex: Find Text Patterns
Section Overview
Regex Metacharacters and Flags (13:20)
Quantifiers (+Greedy and Lazy Matches) (9:33)
More Metacharacters (16:44)
search() and findall() (7:20)
Exercises (9:30)
Text Processing: Automate TXT and CSV files
Section Overview
Introduction to Pandas DataFrames and Numpy Arrays (6:24)
Create a TXT/CSV File with Text Data (10:15)
Add Characters to Each Line in CSV Files (12:39)
Remove Characters From Each Line in CSV Files (9:55)
Concatenate Data in Multiple TXT/CSV Files (8:26)
Remove Duplicates Within a Column and Drop NaN Values (16:11)
Project 3: Table Extraction
Section Overview
Automate Table Extraction from HTML pages (2:19)
Automate Table Extraction from PDFs (3:25)
Automate CSV Extraction from Websites - Part 1 (6:43)
Automate CSV Extraction from Websites - Part 2 (19:44)
Automate CSV Extraction from Websites - Part 3 (11:58)
Google Sheets
Section Overview
Enable APIs and Download Credentials (6:36)
Create a Spreadsheet with Python (11:42)
Upload data to Google Sheets with Python (10:29)
Edit a Worksheet with Python (11:33)
Excel Reports
Section Overview
Create a Pivot Table with Python (7:24)
Add a Barchart (15:17)
Write Excel Formulas with Python (14:13)
Format Cells (3:43)
Convert Pivot Table to Excel Report (2:26)
Generate Excel Reports with One Click (py to exe) (7:47)
Email
Section Overview
Turn on 2-Step Verification (2:20)
Send an Email with Python (8:21)
Add an Attachment (4:39)
Automate Tasks with ChatGPT
Automate tasks with ChatGPT (11:48)
Automate tasks with ChatGPT - Excel (13:23)
Congratulations!
Section Overview
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock