Automate with Python – Full Course for Beginners

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.

⭐️ 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

🎉 Thanks to our Champion and Sponsor supporters:
👾 Raymond Odero
👾 Agustín Kussrow
👾 aldo ferretti
👾 Otis Morgan
👾 DeezMaster

--

[nazimgolaurb]

I want to thank freeCodeCamp and Frank for demonstrating this. I am taking a course and just learning syntax and to be honest it was difficult to hold my attention. But with the first few minutes of watching this video I feel like your way is so much more effective. I'm learning how to do something that is modern and that I can follow right away. Please keep these videos coming!

[juandavidtorovelez]

Please keep this excellent job up! As someone who loves python and currently learning it, this material is pure diamond!!

[nikhilanandpandit]

⌨️ (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 (masOS)
⌨️ (1:42:16) Project #3 - Automate Excel Report - Create a Pivot Table with Python
⌨️ (1:49:42) Automate Excel Report - Add a Barchart
⌨️ (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

[shikug]

Yo this helped so much and I always appreciate the content and when i found the channel and got the energy from you from the previous video, you've been nothing but real and can vouch for the amazing content and how down to earth you are with everything! All the most love, respect, and appreciation <3

[carloseduardocorreacoimbra]

Dear Frank Andrade, thanks a lot for sharing the Automation Cheat Sheet. Congrats for this class that is amazing!

[limwei]

Thank you!!! Previously when I was learning Python, all the past references were for older version Selenium 3. I was facing difficulty with launching selenium. Now we have a proper guide thank you!

[williamthatsmyname]

This is way batter than I expected. Kudos.

[Educationsupport]

I agree with many comments that say this is not for beginners. Beginner implies someone with no experience could do it. Its not a full beginner course.

[ccy]

OMG!!!! This is the course that I have always hoping for.😆
Thank you for the whole tutorial 🫡

[narbiraymond]

This is the best I have seen on python automation. Kudos for the good job

[d.weltenbummler]

Well done, I could binge it. Easy to use framework, perfect explained. I feel like I can replicate it without knowing anything about python code before.
Automate loops like Dr. Frankenstein and call it Cleon 1.0

[tofuboy]

Awesome, this channel is one of the best learning sources on the internet.

[ghassanjenainaty]

Now am learning the basics of Python like variables & inputs & loops, classes, dictionaries, etc. I guess i have to build good background before moving to Automation

[codingtech]

I never skip add on this channel because it help the channel that provides priceless video

[endermaster]

Perfect timing, Im gonna listen to this like a podcast

[alvaroszi]

Awesome video! Will definitely get to do some of these :D

[lunarbonito]

Woot! Thank goodness, I needed this back on my computer! Thank you!! :D

[BillyT]

Finally a Python Automation Course from freeCodeCamp!!! 👍

[ayushroy]

Wow. I am currently learning automation, great timing for the vid

[maxcohen]

FYI: unless using JUPYTER, you'll need to print out the tables. Typing _len(simpsons)_ on it's own won't produce any results. Instead, type _print(simpsons)._