Automate Your Life With Python + ChatGPT Prize [2024]

Installation and Setup
1 Important Note (+Cheat Sheet for The Course)
2 Installing Python and PyCharm

Python Crash Course (Optional)
3 Section Overview
4 Installing Python and Jupyter Notebook through Anaconda
5 Jupyter Notebook Interface
6 Cell Types and Modes in Jupyter Notebook
7 Hello World
8 Data Types
9 Variables
10 Lists
11 Dictionary
12 If Statement
13 For Loop
14 Function
15 Modules

File and Folder Operations
16 OS vs Path Module
17 Creating Folders and Subfolders
18 Rename Folders and Files & Get Path of All Subdirectories
19 Exercise 1 – Rename file based on parent and grandparent folders
20 Exercise 2 – Change Extension of a file
21 Create and Delete Files
22 Extract Zip
23 Search File

Project 1 Automate Word Documents
24 Filling in Data in Word
25 How to Create Fake Data
26 Word Document Automation

Web Automation & Web Scraping Automate Morning News
27 Section Overview
28 HTML Basics – Tags and Elements
29 HTML Basics – Tree Structure
30 XPath – Syntax, Functions and Operators
31 XPath – Test Your XPath
32 XPath – Special Characters and Syntax
33 Installing Selenium and ChromeDriver
34 Automate The News – Creating The Driver
35 Automate The News – Finding Elements
36 Automate The News – Exporting Data to a CSV File
37 Automate The News – Headless mode
38 Automate The News – Preparing Script to Be Run Everyday
39 Convert py to exe
40 Schedule Python Script with crontab (masOS)
41 Note Schedule a Python Script on Windows
42 Schedule Python Script with Task Scheduler (Windows)

Project 2 Tinder
43 Section Overview
44 Important Note (Updates)
45 Automating Tinder – Building The XPaths
46 Automating Tinder – Adding a For Loop, TryExcepts and Waits
47 Connect Selenium to an Existing Browser
48 Schedule Python Script

Regex Find Text Patterns
49 Section Overview
50 Regex Metacharacters and Flags
51 Quantifiers (+Greedy and Lazy Matches)
52 More Metacharacters
53 search() and findall()
54 Exercises

Text Processing Automate TXT and CSV files
55 Section Overview
56 Introduction to Pandas DataFrames and Numpy Arrays
57 Create a TXTCSV File with Text Data
58 Add Characters to Each Line in CSV Files
59 Remove Characters From Each Line in CSV Files
60 Concatenate Data in Multiple TXTCSV Files
61 Remove Duplicates Within a Column and Drop NaN Values

Project 3 Table Extraction
62 Section Overview
63 Automate Table Extraction from HTML pages
64 Automate Table Extraction from PDFs
65 Automate CSV Extraction from Websites – Part 1
66 Automate CSV Extraction from Websites – Part 2
67 Automate CSV Extraction from Websites – Part 3

Google Sheets
68 Section Overview
69 Enable APIs and Download Credentials
70 Create a Spreadsheet with Python
71 Upload data to Google Sheets with Python
72 Edit a Worksheet with Python

Excel Reports
73 Section Overview
74 Create a Pivot Table with Python
75 Add a Barchart
76 Write Excel Formulas with Python
77 Format Cells
78 Convert Pivot Table to Excel Report
79 Generate Excel Reports with One Click (py to exe)

Emails
80 Section Overview
81 Turn on 2-Step Verification
82 Send an Email with Python
83 Add an Attachment

Automate tasks with ChatGPT
84 Section Overview
85 Automating Multiple tasks with ChatGPT
86 Automate Web Scraping with ChatGPT Plugin
87 Automate Web Scraping with ChatGPT Code Interpreter
88 Automate Data Analysis with ChatGPT code interpreter
89 Automating Excel with ChatGPT
90 Congratulations!

Appendix (Older Content WhatsApp Project)
91 Note
92 Section Overview
93 Basic Automation with pywhatkit – Sending Messages to Contacts and Groups
94 Automate WhatsApp with Selenium – Sending Messages
95 Automate WhatsApp with Selenium – Sending a Photo
96 Automate WhatsApp with Selenium – Connect Selenium to an Existing Browser
97 Automate WhatsApp with Selenium – Adding Waits
98 Automate a Good Morning message – Preparing Script to Be Run Everyday
99 Schedule Python Script with crontab (macOS)
100 Note Schedule a Python Script on Windows