Automate your job with Python

  Рет қаралды 319,356

John Watson Rooney

John Watson Rooney

Жыл бұрын

DISCORD (NEW): / discord
Learning automation with Python and Playwright can save you hours of work! Use the codegen feature to make it easy too
Patreon: / johnwatsonrooney
Scraper API www.scrapingbee.com/?fpr=jhnwr
Donations: www.paypal.com/donate/?hosted...
Proxies: proxyscrape.com/?ref=jhnwr
Hosting: Digital Ocean: m.do.co/c/c7c90f161ff6
Gear I use: www.amazon.co.uk/shop/johnwat...
Disclaimer: These are affiliate links and as an Amazon Associate I earn from qualifying purchases

Пікірлер: 229
@rumble1925
@rumble1925 3 ай бұрын
I'm a programmer but I run my own business. I can't believe I never thought of automating admin tasks. I hate doing admin and I put it off to the last possible moment.
@johndavidwoodcock4528
@johndavidwoodcock4528 3 ай бұрын
I also run a business, just to help we with some ideas what kind of admin work do you have in mind?
@3g0e
@3g0e 21 күн бұрын
What tasks are you referencing?
@HaggisMuncher-69-420
@HaggisMuncher-69-420 13 күн бұрын
@@johndavidwoodcock4528 The guy isn't a programmer, if he was, he'd know to automate tasks.
@JosejuanBlanco10
@JosejuanBlanco10 3 ай бұрын
This is exactly, and i mean EXACTLY what i’ve been looking for!!! I can’t thank you enough.
@54tomcat
@54tomcat 3 ай бұрын
That was cool! In my first weeks right now studying and learning Python. Wanted to see some live coding, and that was so interesting 🤩. Thanks for sharing!!!
@bmccollum
@bmccollum Жыл бұрын
Can't tell you how very much I enjoy your Python-related videos. I always watch them and walk away having learned something new or at least having learned how to do something I already know in a better way. 🙂
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
thanks great! thank you you are very kind
@jordiwang
@jordiwang 11 ай бұрын
my man, thanks a lot. This is actually what I was looking for and I am sure this is a MUST skill that everyone should have. So good. Love you
@davidl3383
@davidl3383 Жыл бұрын
This record fonction is incredible ! thank you John !
@waellerbe
@waellerbe Жыл бұрын
Today you have a **new** Subscriber to your channel. I am totally impressed with the value of Playwright powered by Python. Thank you for sharing this tutorial with us. Automating our jobs will boost our efficiency to a high degree. Ready to keep on learning along the way.
@minevr5839
@minevr5839 Жыл бұрын
Awesome as always. Thank you John.
@training7574
@training7574 Ай бұрын
Very inspiring, thanks! Amazing that it should be so simple.
@vrk4y
@vrk4y Жыл бұрын
Thanks for such useful content, John. I used the library a few times before, but I hadn't known about the codegen. It'll definitely make my new project development easier
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
Glad it was helpful!
@jw200
@jw200 10 ай бұрын
Thanks so much for showing Playwright. Its excellent. Makes stuff so much easier.
@aetheon9906
@aetheon9906 3 ай бұрын
Class. Explained well, concise, with example. Love it!
@graczew
@graczew Жыл бұрын
Good stuff as always. Thanx for sharing your knowledge and time.
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
thanks mate hope all is good with you!
@Metalmatt900
@Metalmatt900 3 ай бұрын
This is what I’ve been looking for. Thank you so much.
@carlos-ferreira
@carlos-ferreira Жыл бұрын
Thank you for tutorials like this. I recently used another one of your videos to fix the code a previous employee had created.
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
Great to hear!
@sepehrsarjami
@sepehrsarjami Ай бұрын
Absolutely enjoyed it. Nicely done.
@LucasMartins-op7oq
@LucasMartins-op7oq 3 ай бұрын
Wow, this is awesome! Thanks for sharing.
@PeterThornton
@PeterThornton 3 ай бұрын
This is fantastic, i need to do repeated tests on a newly developed webpage, this is perfect. I have subscribed and check out your other videos. Thank you
@danlee1027
@danlee1027 Жыл бұрын
Very helpful. I didnt know about code gen recording.
@swhitt4367
@swhitt4367 2 ай бұрын
Subscribed, if this was a series of examples and queries and question answering I would say you would have a keen audience! Subscribed
@irfanshaikh262
@irfanshaikh262 Жыл бұрын
See. When i sit dow to count my blessings, i count "finding this channel and John" in particular probably a million times. Thanks john for being there for me.
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
that is very kind, thank you for watching
@sagedoescode
@sagedoescode Жыл бұрын
simple and straighforward, good stuff mate
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
thanks
@quangminhnguyen5681
@quangminhnguyen5681 9 ай бұрын
very cool very useful. thanks man
@BERNOUSSAMA
@BERNOUSSAMA 8 ай бұрын
Thanks man. Never knew playwright had a codegen until now.
@dundy96
@dundy96 5 ай бұрын
This is going to make inputing student grades SO much easier.
@amogu_07
@amogu_07 9 ай бұрын
this is one of the coolest thing ive watched tnkuu
@spookimiiki5891
@spookimiiki5891 10 күн бұрын
simple yet effective, the python way! nice video!
@isekaijoucho4812
@isekaijoucho4812 Ай бұрын
a casual dig into learning python led me here? to this crazy advanced automation? should've done python long ago
@jeS77791
@jeS77791 Жыл бұрын
Thank you, as always John!
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
thanks for watching!
@pkavenger9990
@pkavenger9990 Жыл бұрын
wow this is so much better than selinium, I mean you don't even have to code just perform things on browser and it will convert it into code and you can then use it to automate stuff. Amazing
@michaelmuolokwu5039
@michaelmuolokwu5039 Жыл бұрын
Thank you for this!
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
thanks for watching!
@AMindInOverdrive
@AMindInOverdrive 6 ай бұрын
This is great! Thanks
@Emre-yx6vw
@Emre-yx6vw 4 ай бұрын
I couldn't stop laughing from happiness. Thank you man, thank you!
@valuetraveler2026
@valuetraveler2026 Жыл бұрын
next level scraping here- will check it out
@Cu-da
@Cu-da Жыл бұрын
First of all thanks for the useful video. I've already learned python basics and now trying to get into automation and web scraping world and while i'm searching on youtube i found your useful channel but i found many playlists and i hope if you can tell me which playlist i should start with as a begginer in this world.
@AlwaysBored1
@AlwaysBored1 4 ай бұрын
I'm going to try using this method to clock in and out of work each day!
@bcavalcante
@bcavalcante Ай бұрын
Tragam um Oscar para esse cara!
@isagive
@isagive 4 ай бұрын
Its awesome! lets conenct this to a database and create some schemas... +10 for making such a tutorial.
@TheEamonKeane
@TheEamonKeane Жыл бұрын
Very cool John
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
Thanks I appreciate it
@loicleray
@loicleray Жыл бұрын
Interesting, as always. Thanks 😊
@andrewlimmmmm
@andrewlimmmmm Күн бұрын
thank you bro you are the best
@victoraguirre7486
@victoraguirre7486 3 ай бұрын
I liked the video, unliked it and re-liked it again so I could like it more. Thanks man!!
@EnzoAuditore
@EnzoAuditore 10 ай бұрын
Thanks mate
@justsh0t
@justsh0t 5 ай бұрын
lol this codegen looks amazing :O
@okoeroo
@okoeroo 4 ай бұрын
Great find
@dhanashekaranm4725
@dhanashekaranm4725 14 күн бұрын
useful video thanks
@devkhare5691
@devkhare5691 4 ай бұрын
That recording part looks like the universal recorder from Automation Anywhere 360.
@rico5424
@rico5424 13 күн бұрын
That’s awesome! So you would just have to change the numbers and run the script and let it do it for you. That’s cool
@harrazmasri2805
@harrazmasri2805 8 ай бұрын
kudos to you sir
@nssdesigns
@nssdesigns 3 ай бұрын
Great stuff... is there a way to read .xlms or csv data and loop through each row to automate web form entry data?
@walterclements7968
@walterclements7968 3 ай бұрын
wow. crazy how easy it is
@Gunat737
@Gunat737 3 күн бұрын
Interesting tutorials
@matthewj6026
@matthewj6026 3 ай бұрын
I love how the thumbnail of this video has some text reading "work smarter" with an arrow pointing to a screen of code on it. It's just brilliant.
@matthewj6026
@matthewj6026 3 ай бұрын
Oh I forgot the "automate" bit- genius! Then the video starts with a man talking into a big microphone stuck right in his face, a must have for the KZfaq podcaster or today. Also, the look of contemplation on his face as he's talking through his techniques
@tr0wb3d3r5
@tr0wb3d3r5 3 ай бұрын
​@@matthewj6026HAHAHAHAAH hi gpt4
@moler512
@moler512 3 ай бұрын
huh?
@mortazabaqeri1838
@mortazabaqeri1838 3 ай бұрын
Hahaha what is bro saying?
@Septumsempra8818
@Septumsempra8818 Жыл бұрын
Playwright never ceases to surprise
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
Yeah you can do a lot just by controlling a browser
@daesagelmar
@daesagelmar Жыл бұрын
Hello, I think playwright has some pre-installation dependecies. I could not execute codegen generated code in VSCode due to library dependency problems. When i dig into stackover flow lot of questions raised to handle this library properly. Could you tell us how do you handle this issues? i mean "playwright.sync_api" could not resolved.
@zettatech_dev
@zettatech_dev Жыл бұрын
thanks!
@mehuljy
@mehuljy 7 ай бұрын
Hi John, is it possible to add time stamps for each step that is being captured
@PankajThakur-jq1td
@PankajThakur-jq1td Жыл бұрын
Hey John, How can we scrape a page which requires zipcode to open the actual data to scrape and various navigations to go the data.
@ahmed007Jaber
@ahmed007Jaber 3 ай бұрын
hi John, this sounds intersting. Do you code in R? found helpful resources for R? I have been coding in R for couple of years and planning to stick with it unless I have to change
@aminehadjmeliani72
@aminehadjmeliani72 Жыл бұрын
Thanks John for the great content, my I suggest you to make video about scraping thousands of websites asynchronously using scrapy
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
good idea, big task - i can certainly look at something that would help
@urielmedina8449
@urielmedina8449 6 ай бұрын
Hi! Can you use this for exe’s? For example i have an app at work that i have to use to process charges. Its slow and has a few points where i have to wait to load, but for the most part its pretty repeatable.
@robertwallace5498
@robertwallace5498 4 ай бұрын
I wish my job had more of these tasks so I could automate them
@nunyo7259
@nunyo7259 15 күн бұрын
Might need this to book my T times
@malwaredev33
@malwaredev33 Жыл бұрын
Good content as always, Thanks for that fantastic knowledge base videos, bro. I learn many things from your videos about scraping with python, Now I'm learning API web scraping. Make or suggest some good videos about web scraping through API. using python or making a video with complete detail. Thank You, John
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
thanks for watching, and great video suggestions thank you!
@malwaredev33
@malwaredev33 Жыл бұрын
@@JohnWatsonRooney Don't worry I'm also a python lover so I know how much hard it take to make this type of content.
@sweetlulu4306
@sweetlulu4306 Жыл бұрын
Thank you, I really enjoy how you explain and walk through the steps. I am curious about the password part tho. Is there a better security method for the username password part? I would hate to have this script to be sitting there on my desktop at work. Just wondering what’s the best security practice for that 😊
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
Hey thanks- you could add user input at the start of the script, asking for the user to input the password required then stopping you having it saved
@alexdin1565
@alexdin1565 Жыл бұрын
Thanks Jhon please can you make a video on how we can use selenium or playwright on cpanel to make it run 24/24?
@ngaiyuchan7886
@ngaiyuchan7886 4 ай бұрын
selenium seems cant use back the cookies for specific website, how about this library, thanks
@ouchvinny4520
@ouchvinny4520 4 ай бұрын
Question, how does your terminal look so clean?
@Puundaa
@Puundaa 3 ай бұрын
Hi, can I use this for automatic testing of a webpages as well? If so, how can I store the passed and failed parts?
@aslmate
@aslmate 5 күн бұрын
Do you think this could work with multiprocessing or multithreading in python? Like opening up many instances of the same process at the same time? How would you change the code so that every error is handled during runtime and to make sure it cannot fail?
@josephreagan9545
@josephreagan9545 3 ай бұрын
You should use playwright to automate clicking the "I am a human" button!
@mateip2002
@mateip2002 11 ай бұрын
Can you pull information from emails for the code to paste it into the API?
@os3990
@os3990 3 ай бұрын
Is there a way to not hardcode the values but refer them to another source eg an excel?
@luffytaro689
@luffytaro689 17 күн бұрын
Holy shit new programmers have it so fucking easy. I remember when we had to use selenium and find each and every HTML path for each click.
@TurokAgi
@TurokAgi Жыл бұрын
I accidentally entered the smart side of KZfaq. My brain hurts 😖
@ciaranflynn6291
@ciaranflynn6291 4 ай бұрын
If I have to perform a task that requires two chrome tabs open at the same time and a "click event" of a chrome extension... would it work?
@maziarzarea2540
@maziarzarea2540 Ай бұрын
never thought of using this to automate tasks in wordpress.... how many million clicks has it been....
@shawn_magnum9208
@shawn_magnum9208 19 күн бұрын
How do i update the code to log in to my utility portal and download the monthly bill? How can i dynamically tell it to download the latest bill since every new bill will have a different name?
@ouassildahimene4635
@ouassildahimene4635 Жыл бұрын
Thanks a lot john, can you make a video about scraping linkedin jobs with playwright ?
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
Thanks for watching - you can apply the same principles here but linked in has more bot protection to get around. I’m moving away from specific site scraping videos but the methods will be adaptable to the sites you want to scrape
@user-xy9sq3lg7m
@user-xy9sq3lg7m 9 ай бұрын
is there code that can automate an excel sheet that needs checking and updating based off latest available data from a number of other spreadsheets? e.g. there is an item code which can be used to lookup different types of information from other sheets, the item code will be present in each other sheet so all that it needs to do is lookup that item code and then input the latest data for that code into my desired spreadsheet. There is also a cell that needs to return a list of "countries" that item code is available in, im unsure where to start or how to go about this
@ktsai24
@ktsai24 6 ай бұрын
You'll want to look into Excel macros. Otherwise if you're on Windows, Microsoft Power Automate is a low-code option.
@ImSilverstar
@ImSilverstar 3 ай бұрын
How do you export the code so that it can be a clickable link on your desktop?
@urmotiva
@urmotiva 6 ай бұрын
What is this theme called in VS?
@jasperbaumgarten3612
@jasperbaumgarten3612 4 ай бұрын
Are you able to make it change the date to one day later every time you run it? Also are you able to make it repeat so it completes this entire task say 5 times?
@JohnWatsonRooney
@JohnWatsonRooney 4 ай бұрын
Yes both of those are possible and relatively simple to implement
@zachhalliwell553
@zachhalliwell553 12 күн бұрын
Do you have to run it from the script window? Or could I save the script and run it while I'm in a browser at the page I want to run the script on?
@JohnWatsonRooney
@JohnWatsonRooney 12 күн бұрын
You can do it that way - you can connect to an open chrome browser using the CDP protocol. It’s relatively straight forward to figure out
@this_is_elvis
@this_is_elvis 8 ай бұрын
amazing
@bashartabbakh6299
@bashartabbakh6299 4 ай бұрын
very nice
@johnlenoob6951
@johnlenoob6951 4 ай бұрын
Hi SIr, what is your coding environment ? YOu recommend use of conda or miniconda ? Working on windaube and don t want to destroy my poor system ;) Thanks for your work and knowkledge wharing
@JohnWatsonRooney
@JohnWatsonRooney 4 ай бұрын
I just use Python and venv - no need for anaconda unless you are a data scientist in my opinion
@johnlenoob6951
@johnlenoob6951 3 ай бұрын
Thanks sir @@JohnWatsonRooney
@WavyTrends1
@WavyTrends1 Ай бұрын
how can I have my program stop and repeat the script again when a specific value goes up on my screen? ex. the number value is at 20. how can I make the script stop when value increases?
@AllVIDEO4You
@AllVIDEO4You 10 ай бұрын
Can I uninstall any application on my system using Playwright
@PoseidonLP
@PoseidonLP 4 ай бұрын
Holy shit, this really does replace selenium
@Digitalachievement
@Digitalachievement 2 ай бұрын
How are you supposed to deal with 2 factor authentication? For example if you need to log into a website with your google account but you have 2 factor authentication?
@11bftw
@11bftw 21 күн бұрын
Bros got the gamer dent, ima believe what he says
@JohnWatsonRooney
@JohnWatsonRooney 20 күн бұрын
Hahaha
@11bftw
@11bftw 20 күн бұрын
@@JohnWatsonRooney all love ❤️
@davidghisk3470
@davidghisk3470 Жыл бұрын
Great
@arsalan0561
@arsalan0561 Жыл бұрын
is this possible with selenium ? as i use scrapy-playwright which doesn't work on windows..
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
Yes very possible with selenium, I started with selenium but moved on to Playwright as i preferred the API
@makie1467
@makie1467 Жыл бұрын
Hey there, thank you so much for your great videos. How can i connect google sheets with playwright? Everytime I try to access google it says it is unsafe and I cant login.
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
If you are trying to get data from google sheet with python there is a google api you can use and a Python package to help - it’s a much better way and it allows you to read and write data to a sheet programmatically. It’s called gsheets I believe
@monicadesai7928
@monicadesai7928 Ай бұрын
Can you please make video for scraping job roles from individual company career web pages, so we only have to once add those web pages url, rest will be done by script and then automate the modification of job description into resume by removing some words. Please make videos on it.
@Nostrada-mus
@Nostrada-mus 2 ай бұрын
Playwright runs on private nav. Managed to make it work on guest but can't get it to run on any of my chrome's profile. Any idea how to fix this?
@duyduy5595
@duyduy5595 Жыл бұрын
Does we have to create some delays every time we input something to make it human like? Will the website manager know that we are using Python/Playwright on their site and block our IP?
@JohnWatsonRooney
@JohnWatsonRooney Жыл бұрын
It depends. I think a lot of cases no, you will be fine. I have read about others though where people have had to mimic real mouse movements and time delays
@senecanoles
@senecanoles 2 ай бұрын
My python doesn't look like that, I have to run it in Terminal. How do I get to this window in the begining of the video?
@shaakirjohaar754
@shaakirjohaar754 3 ай бұрын
After installing playwright using the pip3 command , when trying to install chromium, it says playwright is not found Please do let me know if there are other requirements one needs before running these commands on mac m1
The most important Python script I ever wrote
19:58
John Watson Rooney
Рет қаралды 91 М.
5 Amazing Ways to Automate Your Life using Python
18:40
Internet Made Coder
Рет қаралды 183 М.
100❤️ #shorts #construction #mizumayuuki
00:18
MY💝No War🤝
Рет қаралды 16 МЛН
Don’t take steroids ! 🙏🙏
00:16
Tibo InShape
Рет қаралды 74 МЛН
Normal vs Smokers !! 😱😱😱
00:12
Tibo InShape
Рет қаралды 114 МЛН
Are You Still Using Excel? AUTOMATE it with PYTHON
7:19
John Watson Rooney
Рет қаралды 46 М.
26 Incredible Use Cases for the New GPT-4o
21:58
The AI Advantage
Рет қаралды 574 М.
Create A Python API in 12 Minutes
12:05
Tech With Tim
Рет қаралды 540 М.
3 PYTHON AUTOMATION PROJECTS FOR BEGINNERS
17:00
Internet Made Coder
Рет қаралды 1,5 МЛН
5 Useful F-String Tricks In Python
10:02
Indently
Рет қаралды 244 М.
5 Good Python Habits
17:35
Indently
Рет қаралды 331 М.
Introducing Python in Excel
19:01
Leila Gharani
Рет қаралды 1,4 МЛН
Start Automating Your Life Using Python! (File Management with Python Tutorial)
13:07
Time To Switch To Linux?
10:55
Britec09
Рет қаралды 19 М.
AUTOMATE YOUR LIFE USING PYTHON - 3 Beginner Projects (tutorial)
19:42
Internet Made Coder
Рет қаралды 105 М.
Xiaomi Note 13 Pro по безумной цене в России
0:43
Простые Технологии
Рет қаралды 1,8 МЛН
Обманет ли МЕНЯ компьютерный мастер?
20:48
Харчевников
Рет қаралды 187 М.
What’s your charging level??
0:14
Татьяна Дука
Рет қаралды 7 МЛН
How much charging is in your phone right now? 📱➡️ 🔋VS 🪫
0:11