Automate with Python – Full Course for Beginners

Course Contents
(0:00:00) Intro
(0:00:31) Project #1 Table Extraction – Extract Tables from Websites
(0:02:53) Table Extraction – Extract CSV Files from Websites
(0:09:38) Table Extraction – Extract Tables from PDFs
(0:13:06) Project #2 – Web Automation & Web Scraping – HTML Basics – Tags and Elements
(0:20:57) Web Automation & Web Scraping – HTML Basics – Tree Structure
(0:24:22) Web Automation & Web Scraping – XPath – Syntax, Functions and Operators
(0:28:06) Web Automation & Web Scraping – XPath – Test Your XPath
(0:33:38) Web Automation & Web Scraping – XPath – Special Characters and Syntax
(0:38:17) Automate The News – Installing Selenium and ChromeDriver
(0:40:34) Automate The News – Creating The Driver
(0:44:46) Automate The News – Finding Elements
(1:04:34) Automate The News – Exporting Data to a CSV File
(1:12:34) Automate The News – Headless mode
(1:18:18) Automate The News – Preparing Script to Be Run Everyday
(1:30:17) Automate The News – Convert py to exe
(1:37:18) Automate The News – Schedule Python Script with crontab (macOS)
(1:42:16) Project #3 – Automate Excel Report – Create a Pivot Table with Python
(1:49:42) Automate Excel Report – Add a Bar Chart
(2:05:02) Automate Excel Report – Write Excel Formulas with Python
(2:19:18) Automate Excel Report – Format Cells
(2:23:04) Automate Excel Report – Convert Pivot Table to Excel Report
(2:25:32) Automate Excel Report – Generate Excel Reports with One Click (py to exe)
(2:33:22) Project #4 – Automate WhatsApp