Automate with Python – Full Course for Beginners

By freeCodeCamp.org
Published: Jun 20, 2022

“
Learn how to automate your life with Python! You will learn how to automate boring and repetitive tasks such as creating an Excel report, sending text messages, extracting tables from websites, interacting with websites, and more. You will learn how to use a few different Python libraries to help with automation such as Path, Selenium, XPath, and more.

Source Code & Datasets: https://github.com/ifrankandrade/auto…

– Course from Frank Andrade. Check out his YouTube Channel: https://www.youtube.com/c/FrankAndrade5
– Automation Cheat Sheet: https://frankandrade.ck.page/44559e1ae7
– Frank’s 11-Hour Automation Course in Python: https://www.udemy.com/course/automate…
– Frank’s Discord Server: https://discord.gg/6xyQaj8bJK

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

[READ MORE]

”