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.
Overview
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.
Taught by
freeCodeCamp.org
Related Courses
-
Python Automation Tutorial – How to Automate Tasks for Beginners [Full Course]
-
Web Scraping Tutorial with Scrapy and Python for Beginners
-
Web Scraping in Python
-
Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)
-
Advanced Selenium Techniques and Framework Introduction
-
Master Python Web Scraping & Automation using BS4 & Selenium
