Automate with Python - Full Course for Beginners

Подписаться 9 млн

Просмотров 1,5 млн

50% 1

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: github.com/ifrankandrade/auto...
✏️ Course from Frank Andrade. Check out his RU-vid Channel: / frankandrade5
🔗 Automation Cheat Sheet: artificialcorner.com/p/redeem...
🔗 Frank's 11-Hour Automation Course in Python: www.udemy.com/course/automate...
🔗 Frank's Discord Server: / discord
⭐️ 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: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

Опубликовано:

19 май 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 333

@juandavidtorovelez5979 Год назад

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

@nazimgolaurb618 Год назад

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!

@nikhilanandpandit8644 Год назад

⌨️ (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

@sanathkumarshenoy9955 Год назад

Thanks mate

@sleepstorm1192 Год назад

Thanks

@hassaan_bm Год назад

Thank you..

@josephlee6865 Год назад

Hey, is this something that you typed out manually or is it something you were able to use code to get?

@bringbackdislikes3195 7 месяцев назад

@@josephlee6865 He copy pasted it from the description...

@shikug6939 Год назад

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

@limwei2634 Год назад

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.

@ccy920 Год назад

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

@narbiraymond8375 Год назад

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

@d.weltenbummler1535 Год назад

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

@carloseduardocorreacoimbra4040 Год назад

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

@vamshikittu8635 24 дня назад

hi i'm a student can you share me the cheetsheet please.

@endermaster08 Год назад

Perfect timing, Im gonna listen to this like a podcast

@Educationsupport 6 дней назад

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.

@Icarus47249fd 2 дня назад

It doesn’t matter if we know the concepts if we don’t know how to apply these tools. It’s okay you know Python, you know all the fundamental, now go make something with it, but what do you right? How do you develop your skills that would eventually land a job at a tech company? That’s an entirely different story. Most of the time, people are just wasting their time attempting to figure out ‘the path.’ Wouldn’t it be amazing to just know, this is the projects you’ll need to make to solidify specific skills. From there, you’ll branch out to other languages, and eventually landing a coding job. Unfortunately, it’s a headache knowing where to begin. The tech industry feels like a place where the people who were great at coding were groomed from the beginning, they already have this established path from relatives who went through this. There’s so much information out there on the internet (amazing), but you don’t know which you should focus your time and energy on.

@CaptainJuiccy Год назад

This is actually insane, thank you!!!

@arturocdb Год назад

Great explanation, thank so much!

@gautammenariya8292 Год назад

yet another great tutorial, love this

@lunarbonito Год назад

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

@tofuboy9269 Год назад

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

@codingtech2502 Год назад

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

@sanjananayak6326 Год назад

This is what I needed. Thank u❤️

@rfsnjn Год назад

what a perfect time, i just started python

@dnyaneshwar53 Год назад

Same here ✌️✌️✌️✌️

@helloworldfromvn Год назад

same here, really need this 😂

@AkramBazina Год назад

Welcome to the club

@ayushroy3514 Год назад

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

@dansierrasam79 10 месяцев назад

Thank you, sir. Excellent work!

@BillyT83 Год назад

Finally a Python Automation Course from freeCodeCamp!!! 👍

@NovaTech2010 Год назад

Thank you for this tutorial!

@ghassanjenainaty4212 Год назад

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

@alvaroszi Год назад

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

@SmallMindEd69 14 дней назад

This code instructor is amazing!!!

@muhammednihal2410 Год назад

Awesome!!! Thank you ❤

@vijayalakshmiraj7528 Год назад

TNice tutorials was an amazing tutorial. You are a great teacher

@labinotsulejmani1137 9 месяцев назад

Hi everyone! First of all, thank you guys for this amazing content that you keep delivering! You are the world's No 1 free school for learning Tech! Now to my question: i run the first 2 programs with success but it doesn't give me the output as in the video. Doesn't matter if i rung it from VS Code, git bash or cmd. The program runs successful but the output is not as expected with the lists. Can you someone help?

@iDarkXY Год назад

this helped tremendously. THANK U

@sonamohialdin3376 Год назад

Amazing tutorial thank you

@maxcohen13 Год назад

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)._

@sigfigronath Год назад

Wow so easy ! great course

@cheybrown2076 2 месяца назад

Nice video to just binge. Thanks for this

@jitendratiwari6886 Год назад

Wow thank you for sharing this to us.

@mehdismaeili3743 Год назад

Excellent, thanks.

@aashishmalhotra Год назад

Wow very useful i will complete it after finishing with 8 sem exams

@theobaldigberaese4572 Год назад

Awesome work mentor... I hope to meet you someday

@sab311 Год назад

I must jump on this. So inspiring. Thank you

@manikandanshanmugam7480 6 месяцев назад

Nothing but ❤ for this course

@donsurlylyte Год назад

these kind of real world applications of python are real gold, i look forward to them

@hasanmougharbel8030 Год назад

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.

@ermoulis Год назад

very good , thank you!!

@mahendranath2504 Год назад

Thank you so much 😊👌👍👋👍

@mohammadashrafbinizham7985 Год назад

although i am new, it's understandable explanation 👍👍

@fmictsang8874 Год назад

This is amazing.

@iggaming948 Год назад

After learning from 12hrs. Video now I think 2hrs. Video is shorter for me I can easily learn from them ♥️😀🖐️

@sanjith_sambath Год назад

For those of you getting a certificate error : import ssl ssl._create_default_https_context = ssl._create_unverified_context ^ Worked for me :D

@jacquacooper Год назад

Just what I needed

@matthewsteele1671 Год назад

Thank you for the amazing content! It would be very helpful if you mentioned which code editors or ide's you use when you switch from jupyter though. I tried to download the cheat sheet but it sent me in circles. Thanks again!

@braxindor4153 Год назад

He said it multiple times though? It's called pycharm. It's the jetbrains option. You can use visual studio code or similar and that'll be great as well though.

@parthasarathyvenkatachari2617 Год назад

super video pls continue other topics of any other language

@imnedmonton Год назад

I'm hooked. A thousand years away from assembler, COBOL, Fortran, Pascal. Champagne vs. cheap beer.

@dnyaneshwar53 Год назад

Your are awesome... Thank you so much for this course 😍✌️✌️✌️✌️

@TheOnlyEpsilonAlpha 6 месяцев назад

I‘m at 1:17 and first i have to say something: THANK YOU FOR USING A PROPER MIC!❤ Cheeses crisis, the last 5 Videos I watched before, there have been people, without proper English speaking or the worse mic quality or a combination of both. Or a lady which hammered her keyboard right beside the microphone. How should someone proper learn from that content? 1:52 Okay the CTRL Key seems to be right beside your mic right? Each time to copy or paste something it‘s clear you pressed a key very loud. 3:00 what happened? You sound so much quieter 8:53 But if i turn it up it‘s okay. Anyway it‘s a way better video than the other ones i watched before! 19:29 i love that someone really specifies all the tags you find in that chaos of a modern website, very well explained 👍 Gone through the whole video and it was VERY interesting 😮 thanks for that tutorial

@TiagrajI Год назад

Great one. I love it. It helps in daily life

@kakafrost 9 месяцев назад

Hey thanks! In the scraping part, what do you do with this error: "ERROR: Couldn't read tbsCertificate as SEQUENCE" "ERROR: Failed parsing Certificate" ?

@reng7777 Год назад

THKS!!!!! I WILL CHECK THIS VIEO AFTER MY OFFICE HRS!!!

@just_ab01 3 месяца назад

Thanks!

@ersalomositorusdori308 Год назад

thanks very much i hope this tutorial would be helped ,thanks a lot

@hongyuanqiu4115 Год назад

Thank you.

@jheandaza7334 Год назад

Wow!! Beatiful content!

@othnieldavidson7579 Год назад

nice tutorials sir i wanted to ask if there is a library to fetch images online...

@mecreature Год назад

Awesome 😍😍😍

@Martin-yo8wh Год назад

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.

@Mr0rris0 Год назад

What about LASERS!!!@!@@@@ And duck hunt. This can be solved with over engineering SUBSCRIPTION LASERS!!!!!!!

@dhruvpandey3642 9 месяцев назад

Agreed, Finally someone telling it like it is instead of fanboying

@Lorendrawn 8 месяцев назад

About to end all my teammates' careers with the learnings from this video ayyyy

@themuhammad1 Год назад

Thank you so much 😭😭❤️❤️❤️😍😍😍

@hadigunawan7797 Год назад

big thanks ❤❤

@SpwnTheBitcoinOverlord Год назад

A tutorial regarding Filemaker?? It would be pretty useful!

@ultraenergy313 Год назад

Thank You

@hayat_soft_skills Год назад

Cool !!!! Thanks!

@user-bf5os3fo9m Год назад

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.

@gameplay6751 Год назад

Thanks a lot ❤️, if you record video how to automat wordpress after we scrap the data

@immipixediter210 Год назад

thanks

@kalelsoffspring Год назад

Some of this information was neat and helpful, but I definitely felt like it wasn't well paced. There was a lot of "I've shown this before so I'll go over it really quick" that we literally didn't get to see