Automate Your Life With Python + ChatGPT Prize [2024]

Course Curriculum

Chapter 1: Installation and Setup

Lecture 1: Important Note (+Cheat Sheet for The Course)

Lecture 2: Installing Python and PyCharm

Chapter 2: Python Crash Course (Optional)

Lecture 1: Section Overview

Lecture 2: Installing Python and Jupyter Notebook through Anaconda

Lecture 3: Jupyter Notebook Interface

Lecture 4: Cell Types and Modes in Jupyter Notebook

Lecture 5: Hello World

Lecture 6: Data Types

Lecture 7: Variables

Lecture 8: Lists

Lecture 9: Dictionary

Lecture 10: If Statement

Lecture 11: For Loop

Lecture 12: Function

Lecture 13: Modules

Chapter 3: File and Folder Operations

Lecture 1: OS vs Path Module

Lecture 2: Creating Folders and Subfolders

Lecture 3: Rename Folders and Files & Get Path of All Subdirectories

Lecture 4: Exercise 1 – Rename file based on parent and grandparent folders

Lecture 5: Exercise 2 – Change Extension of a file

Lecture 6: Create and Delete Files

Lecture 7: Extract Zip

Lecture 8: Search File

Chapter 4: Project 1: Automate Word Documents

Lecture 1: Filling in Data in Word

Lecture 2: How to Create Fake Data

Lecture 3: Word Document Automation

Chapter 5: Web Automation & Web Scraping: Automate Morning News

Lecture 1: Section Overview

Lecture 2: HTML Basics – Tags and Elements

Lecture 3: HTML Basics – Tree Structure

Lecture 4: XPath – Syntax, Functions and Operators

Lecture 5: XPath – Test Your XPath

Lecture 6: XPath – Special Characters and Syntax

Lecture 7: Installing Selenium and ChromeDriver

Lecture 8: Automate The News – Creating The Driver

Lecture 9: Automate The News – Finding Elements

Lecture 10: Automate The News – Exporting Data to a CSV File

Lecture 11: Automate The News – Headless mode

Lecture 12: Automate The News – Preparing Script to Be Run Everyday

Lecture 13: Convert py to exe

Lecture 14: Schedule Python Script with crontab (masOS)

Lecture 15: Note: Schedule a Python Script on Windows

Lecture 16: Schedule Python Script with Task Scheduler (Windows)

Chapter 6: Project 2: Tinder

Lecture 1: Section Overview

Lecture 2: Important Note (Updates)

Lecture 3: Automating Tinder – Building The XPaths

Lecture 4: Automating Tinder – Adding a For Loop, Try/Excepts and Waits

Lecture 5: Connect Selenium to an Existing Browser

Lecture 6: Schedule Python Script

Chapter 7: Regex: Find Text Patterns

Lecture 1: Section Overview

Lecture 2: Regex Metacharacters and Flags

Lecture 3: Quantifiers (+Greedy and Lazy Matches)

Lecture 4: More Metacharacters

Lecture 5: search() and findall()

Lecture 6: Exercises

Chapter 8: Text Processing: Automate TXT and CSV files

Lecture 1: Section Overview

Lecture 2: Introduction to Pandas DataFrames and Numpy Arrays

Lecture 3: Create a TXT/CSV File with Text Data

Lecture 4: Add Characters to Each Line in CSV Files

Lecture 5: Remove Characters From Each Line in CSV Files

Lecture 6: Concatenate Data in Multiple TXT/CSV Files

Lecture 7: Remove Duplicates Within a Column and Drop NaN Values

Chapter 9: Project 3: Table Extraction

Lecture 1: Section Overview

Lecture 2: Automate Table Extraction from HTML pages

Lecture 3: Automate Table Extraction from PDFs

Lecture 4: Automate CSV Extraction from Websites – Part 1

Lecture 5: Automate CSV Extraction from Websites – Part 2

Lecture 6: Automate CSV Extraction from Websites – Part 3

Chapter 10: Google Sheets

Lecture 1: Section Overview

Lecture 2: Enable APIs and Download Credentials

Lecture 3: Create a Spreadsheet with Python

Lecture 4: Upload data to Google Sheets with Python

Lecture 5: Edit a Worksheet with Python

Chapter 11: Excel Reports

Lecture 1: Section Overview

Lecture 2: Create a Pivot Table with Python

Lecture 3: Add a Barchart

Lecture 4: Write Excel Formulas with Python

Lecture 5: Format Cells

Lecture 6: Convert Pivot Table to Excel Report

Lecture 7: Generate Excel Reports with One Click (py to exe)

Chapter 12: Emails

Lecture 1: Section Overview

Lecture 2: Turn on 2-Step Verification

Lecture 3: Send an Email with Python

Lecture 4: Add an Attachment

Chapter 13: Automate tasks with ChatGPT

Lecture 1: Section Overview

Lecture 2: Automating Multiple tasks with ChatGPT

Lecture 3: Automate Web Scraping with ChatGPT Plugin

Lecture 4: Automate Web Scraping with ChatGPT Code Interpreter