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.

💻 Source Code & Datasets:

✏️ Course from Frank Andrade. Check out his YouTube Channel:
🔗 Automation Cheat Sheet:
🔗 Frank’s 11-Hour Automation Course in Python:
🔗 Frank’s Discord Server:

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

Learn to code for free and get a developer job:

Read hundreds of articles on programming:


50 thoughts on “Automate with Python – Full Course for Beginners”
  1. 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

  2. This course is absolutely terrible. I can't even do the first project, because I am constantly getting errors. I do google searches to find fixes and once I have fixed one error, I get another.

  3. Having issues getting Camelot to load. I installed as per the directions, when I run pip list Camelot-py shows up in the list of packages. I have tried reloading the window, closing and opening VSCode/ my virtual env. I have uninstalled and reinstalled Camelot, I have referenced the documentation and installed per their instructions and still can’t get Camelot to show up.

  4. For those of you getting a certificate error :
    import ssl

    ssl._create_default_https_context = ssl._create_unverified_context

    ^ Worked for me 😀

  5. I have installed camelot-py, ghostscript and tk. I am doing exactly what is shown an I am receiving errors such as No module named 'cv2'. Does anyone know how to resolve this issue?

  6. When you are describing something that is shown in the screen, it would be easier for the viewers to follow if you use some kind of pointer (e.g. a highlighted mouse pointer) instead of just plainly saying the description — noticed this in explanation of xpath syntax; too many descriptions that didn't stick to mind.

  7. God bless your great efforts in this channel.

    I have a simple question to ask as a newbie sql learner.

    Could i manage to channel or extract all sql data generated from an accounting program (based on sql) to our new sql server.

    The reason that we are bounded with the graphical interface of this accounting software as we cant

    come up with any solutions regarding analytics and automation, unless we can tailor and rearrange this sql database based to our specific needs.

    Thanks for helping me.

  8. Excellent content, thanks. How can i implement the new functionality in Python 3.10 os.startfile(path[, operation][, arguments][, cwd][, show_cmd])? I want to open a file in a minimized window.

Leave a Reply

Your email address will not be published.

Captcha loading...