Automate with Python - Full Course for Beginners

[@NovaTech2010]

Thank you for this tutorial!

[@savant_logics]

Thanks!

[@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!

[@hyphenizm]

I think this course may be for people that are beginners in automation, not necessarily beginners in python. That being said, great course!

[@tanbir2358]

00:00 Learn Python automation with pandas library 07:05 Learn how to extract tables from PDFs using Camelot library 20:53 Learn HTML basics and XPath for effective web scraping 28:02 Learn how to use expat expressions with HTML code 41:43 Automate website using Selenium 4 48:01 Learn how to extract specific elements using XPath 1:00:13 Learned how to locate and extract elements from a website 1:06:23 Extract and export headlines to CSV using Pandas 1:18:42 Preparing script for executable file 1:25:11 Learn how to customize file names using f-strings and concatenate variables. 1:37:46 Learn how to schedule an executable file to run at any time using Chrome Tab Guru 1:43:56 Created a pivot table and exported it to an Excel file 1:56:10 Create a bar chart for sales by product line 2:02:12 Learned how to create bar charts and formulas using OpenPyXL in Python. 2:14:24 Learned how to create formulas in a spreadsheet using Python 2:20:29 Convert Python script to executable 2:32:25 Automate Excel reports and send WhatsApp messages using Python 2:38:24 Learned how to send messages in WhatsApp to contacts and groups using Pi WhatKit

[@juandavidtorovelez5979]

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

[@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]

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

[@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.

[@Dusky-Memory]

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.

[@JamesScott-rf4vx]

I am a beginning python programmer and Jupyter that he is using in pycharm is free for 30 Days but mine is still installing and Frank is explaining everything as if you have already installed it so be sure and wait for it to completely upgrade your pycharm I am using the free pycharm too.

[@architmishra015]

Automation isn't something that a beginner should do either way. They should first play with some basic codes. Here beginner is used in the sense that someone who knows how to code in python but has never done any kind of automation

[@vivekjoshi3769]

@@Dusky-Memory You have some really good points there. I have been learning since long. I had my ups and downs. I felt I was lacking projects. Even though my goal is to land a job as a data analyst or product analyst I am definitely going to add an automation project to my CV. I have seen people talking about automation in data industry. Nowadays there are tools to do this at the click of a button but knowing how to do it using code is a another level of expertise.

[@Domfather94]

@@architmishra015exactly. It’s arrogant to think automation and beginner would be used any other way

[@williamthatsmyname]

This is way batter than I expected. Kudos.

[@rfsnjn]

what a perfect time, i just started python

[@dnyaneshwar53]

Same here ✌️✌️✌️✌️

[@helloworldfromvn]

same here, really need this 😂

[@AkramBazina]

Welcome to the club

[@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

[@narbiraymond8375]

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

[@BillyT83]

Finally a Python Automation Course from freeCodeCamp!!! 👍

[@carloseduardocorreacoimbra4040]

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

[@vamshikittu8635]

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

[@SmallMindEd69]

This code instructor is amazing!!!

[@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

[@IndiaFocusNow]

This is what I needed. Thank u❤️

[@tofuboy9269]

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

[@TheOnlyEpsilonAlpha]

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

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

[@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!

[@endermaster08]

Perfect timing, Im gonna listen to this like a podcast

[@ccy920]

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

[@donsurlylyte]

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

[@alvaroszi]

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

[@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

[@CaptainJuiccy]

This is actually insane, thank you!!!

[@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

[@lunarbonito]

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

[@vijayalakshmiraj7528]

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

[@imnedmonton]

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

[@cristofervidre8378]

I think is fine. It is beginning in automation. If you are beginner in phyton then go check those videos first

[@mecreature]

Awesome 😍😍😍

[@cheybrown2076]

Nice video to just binge. Thanks for this

[@ayushroy3514]

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

[@vishalvalo]

for those whose option.headless not working try this instead in the place of option.headless option.add_argument('--headless') option.add_argument('--disable-gpu') option.add_argument('--window-size=1920,1080')

[@sigfigronath]

Wow so easy ! great course

[@iDarkXY]

this helped tremendously. THANK U

[@manikandanshanmugam7480]

Nothing but ❤ for this course

[@gautammenariya8292]

yet another great tutorial, love this

[@arturocdb]

Great explanation, thank so much!

[@ermoulis]

very good , thank you!!

[@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]

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

[@Lorendrawn]

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

[@ภาณุพงศ์จินดารัตน์-พ4ด]

12:40 39:35 47:35 2:22:27 2:30:50 2:32:00

[@labinotsulejmani1137]

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?

[@muhammednihal2410]

Awesome!!! Thank you ❤

[@mahendranath2504]

Thank you so much 😊👌👍👋👍

[@aashishmalhotra]

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

[@jitendratiwari6886]

Wow thank you for sharing this to us.

[@hadiasik]

big thanks ❤❤

[@codingtech2502]

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

[@jheandaza7334]

Wow!! Beatiful content!

[@ambivert_sigma_motivation]

Awesome, thanks!

[@mehdismaeili3743]

Excellent, thanks.

[@jacquacooper]

Just what I needed

[@themuhammad1]

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

[@parthasarathyvenkatachari2617]

super video pls continue other topics of any other language

[@iggaming948]

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

[@sonamohialdin3376]

Amazing tutorial thank you

[@othnieldavidson7579]

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

[@theobaldigberaese4572]

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

[@mohammadashrafbinizham7985]

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

[@juancarlosaguilarlopez9252]

Undoubtedly, Python is the king Programming Language for data processing ......

[@reng7777]

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

[@SOG989]

Automate the Boring stuff 👏

[@fmictsang8874]

This is amazing.

[@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

[@TiagrajI]

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

[@dnyaneshwar53]

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

[@amirrme9372]

I respect you💙💙💙

[@ersalomositorusdori308]

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

[@hongyuanqiu4115]

Thank you.

[@sameeralam5017]

(1:18:18) Automate The News - Preparing Script to Be Run Everyday

[@immanuelsuleiman7550]

This channel is awesome

[@aadarsh8306]

agreed

[@TarenBar]

I wish we get Python, Playwright someday !!

[@TENRI-ANIME]

nice crack i appreciate it

[@positive_energy3131]

Thank You

[@gameplay6751]

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

[@hayat_soft_skills]

Cool !!!! Thanks!

[@sab311]

I must jump on this. So inspiring. Thank you

[@sanjanajain6293]

1:49:42 Gonna do this!

[@jnsound2962]

খুব সুন্দর একটা ভিডিও

[@PeterAstro]

How funny there are a lot of people still think that universities are for learning and so content is free and more

[@Ogk8036]

Where was the table.pdf located before exporting into CSV when extracting the table from the PDF project? Inside the Python project?

[@fatim6081]

Miracle👌

[@robertgarcia2689]

Thanks

[@aigelalimorom2349]

Really work

[@____kklw7148]

great video

[@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.

[@leonelsalah8950]

Hi, tks for your lectures After finishing lesson Automate the news- exporting data at 1:30, file headline.csv only shows many the same contents in all rows, could u tell me how to fix it. Tks

[@healthadvice3091]

9:29 correct me if im wrong but you can do this easily in excel right?

[@SpwnTheBitcoinOverlord]

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

[@bboyrynan2800]

Kindly make Javascript Automation course excel and web scraping Thanks.

[@wtfdoiputhere]

i was reading this as a blog just yesterday

[@purpleivy2431]

In Automate the news (41:24) what his that path? how did he get it?

[@pegah7482]

you guys can read my mind i swear

[@immanuelsuleiman7550]

Beautiful champ

[@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.

[@skeptomai97]

Can't download the cheatsheet. It throws error "Account is cancelled and can not accept new subscribers."