[#Script #Coding] Automate with Python – Full Course for Beginners

Automate with Python – Full Course for Beginners


By freeCodeCamp.org
Published: Jun 20, 2022


freeCodeCamp.org 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

Proudly powered by WordPress
Creative Commons License
EricBrooks.Com® is licensed under a Creative Commons License.

Disclaimer: The views expressed herein are solely those of Eric Brooks. They do not necessarily reflect those of his employers, friends, contacts, family, or even his pets (though my cat, Puddy, seems to agree with me on many key issues.). In accordance to my terms of use, you hereby acknowledge my right to psychoanalyze you, practice accupuncture, and mock you incessantly with every visit. As the user, you also acknowledge that the author has been legally declared a "Problem Adult" by the Commonwealth of Pennsylvania, and is therefore not responsible for any of his actions. ALSO, the political views and products advertised on this site may/may not reflect the views of Puddy or myself, so please don't take them as an endorsement. We just need to eat.



Connect