Automate with Python – Full Course for Beginners

Overview

Dive into a comprehensive Python automation course designed for beginners. Learn to streamline repetitive tasks by extracting tables from websites and PDFs, performing web scraping and automation, creating automated Excel reports with pivot tables and charts, and even automating WhatsApp messaging. Master essential libraries like Path, Selenium, and XPath while working on practical projects such as automating news gathering, generating Excel reports with a single click, and scheduling Python scripts. Gain hands-on experience in converting Python scripts to executable files and setting up automated tasks using crontab on macOS. By the end of this 2-3 hour course, you'll have the skills to significantly boost your productivity through Python automation.

Syllabus

) Intro.
) Project #1 Table Extraction - Extract Tables from Websites.
) Table Extraction - Extract CSV Files from Websites.
) Table Extraction - Extract Tables from PDFs.
) Project #2 - Web Automation & Web Scraping - HTML Basics - Tags and Elements.
) Web Automation & Web Scraping - HTML Basics - Tree Structure.
) Web Automation & Web Scraping - XPath - Syntax, Functions and Operators.
) Web Automation & Web Scraping - XPath - Test Your XPath.
) Web Automation & Web Scraping - XPath - Special Characters and Syntax.
) Automate The News - Installing Selenium and ChromeDriver.
) Automate The News - Creating The Driver.
) Automate The News - Finding Elements.
) Automate The News - Exporting Data to a CSV File.
) Automate The News - Headless mode.
) Automate The News - Preparing Script to Be Run Everyday.
) Automate The News - Convert py to exe.
) Automate The News - Schedule Python Script with crontab (macOS).
) Project #3 - Automate Excel Report - Create a Pivot Table with Python.
) Automate Excel Report - Add a Bar Chart.
) Automate Excel Report - Write Excel Formulas with Python.
) Automate Excel Report - Format Cells.
) Automate Excel Report - Convert Pivot Table to Excel Report.
) Automate Excel Report - Generate Excel Reports with One Click (py to exe).
) Project #4 - Automate WhatsApp.