![Jie Jenn](/img/default-banner.jpg)
- 767
- 17 853 988
Jie Jenn
United States
Registrace 1. 01. 2007
Just an average guy who enjoys data analytics, automation, data engineering, and solve business problems. Just recently moved to Chicago after spent 9 years working in the Silicon Valley + 4 years of living in Taiwan.
For business inquiring, please email me at
jiejenn@LearnDataAnalysis.org
#datanalytics #dataengineering #dataengineer #gcp #python #azure #aws
For business inquiring, please email me at
jiejenn@LearnDataAnalysis.org
#datanalytics #dataengineering #dataengineer #gcp #python #azure #aws
Playwright Python Browser Automation Crash Course | For Beginners
Coming from a heavy Selenium user in the past, Playwright is my go-to framework today for browser automation and web scraping for dynamic web sites. In this Playwright crash course, I will go over the topics required to automate browsers.
The course is aiming for beginner and intermediate Python users who have zero or some experience with Playwright. That means, as long as you have experiencing using Python, by the end of the video, you will learn everything you need to automate most of the web browsers tasks to streamline your workflow.
📋 Source Code: www.patreon.com/posts/111024376
📃 Playwright For Python: playwright.dev/python/
💖 Show Support
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
🌳 Patreon: www.patreon.com/JieJenn (early access to tutorial source code)
✉️ Business Inquiring: CZcams@LearnDataAnalysis.org
00:00 - Agenda
01:38 - Set up Playwright
02:40 - Lesson 1: Navigate Playwright in Python
05:40 - Lesson 2: Control elements
13:07 - Lesson 2: Browser context
14:05 - Lesson 3: Screenshot capture
15:30 - Lesson 3: File download
16:41 - Lesson 4: Mouse interaction
#playwright #crashcourse #python #browserautomation
The course is aiming for beginner and intermediate Python users who have zero or some experience with Playwright. That means, as long as you have experiencing using Python, by the end of the video, you will learn everything you need to automate most of the web browsers tasks to streamline your workflow.
📋 Source Code: www.patreon.com/posts/111024376
📃 Playwright For Python: playwright.dev/python/
💖 Show Support
☕ Paypal: www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
🌳 Patreon: www.patreon.com/JieJenn (early access to tutorial source code)
✉️ Business Inquiring: CZcams@LearnDataAnalysis.org
00:00 - Agenda
01:38 - Set up Playwright
02:40 - Lesson 1: Navigate Playwright in Python
05:40 - Lesson 2: Control elements
13:07 - Lesson 2: Browser context
14:05 - Lesson 3: Screenshot capture
15:30 - Lesson 3: File download
16:41 - Lesson 4: Mouse interaction
#playwright #crashcourse #python #browserautomation
zhlédnutí: 342
Video
Learn Ollama Function Calling By Building A Live Weather AI Agent In Python
zhlédnutí 162Před 21 hodinou
Function calling is probably one of the most important feature you need to know if you want to build highly functional and practical AI applications with Ollama. By incorporating function calling feature, you will be able to build applications with capabilities to call 3rd party APIs allowing you to retrieve live stock price, weather information, browse the web, or even run query against your d...
dbt Tutorial: Run Workflows by Deploying dbt Core in GitHub Codespaces
zhlédnutí 98Před dnem
In this tutorial, you'll learn how to quickly deploy a dbt project from GitHub to a GitHub Codespace and manage it using dbt Core. I walk through the process step-by-step, from creating a repository using the jaffle shop template to setting up the Codespace environment and running dbt. This is ideal for anyone who wants to run their dbt workflow on the cloud. The entire process takes less than ...
OneDrive API Crash Course For Beginners: Automate OneDrive In Python | Step-By-Step Tutorial
zhlédnutí 370Před dnem
OneDrive is a widely used cloud storage service from Microsoft that allows you to store, share, and sync your files across multiple devices. In this OneDrive API crash course, I’ll guide you through getting started with the OneDrive API in Python to streamline your file management and enhance your workflow. 📋 Source Code To All The Examples & MS Graph module: www.patreon.com/posts/source-code-a...
Automate Boring Stuff With Python | Insert Gmail Data In Google Sheets (Step-By-Step Tutorial)
zhlédnutí 350Před 14 dny
Python automation to archive Gmail data into Google Sheets using Python. In this tutorial, I will walk you through every single step from setting up Google Cloud project, create an OAuth account, enabling Google APIs, and script development for this automation project. 📋 Automation Script Source Code (Patreon Silver Support Only): www.patreon.com/posts/source-code-your-110230517 📋 google_api.py...
Clean Up Project Files | dbt Tutorial
zhlédnutí 82Před 14 dny
dbt (Data Build Tool), a popular data transformation framework created by dbt Lab to streamline data pipeline workflow. In this dbt lesson, we will learn how to use the dbt clean command to organize and clean project files. 📃More on dbt: docs.getdbt.com/reference/references-overview Show Support ☕ Paypal: www.paypal.me/jiejenn/5 ☕ Venmo: @Jie-Jenn 🌳 Patreon: www.patreon.com/JieJenn (early acce...
Generate executable SQL output with dbt compile command | dbt Tutorial
zhlédnutí 84Před 14 dny
dbt (Data Build Tool), a popular data transformation framework created by dbt Lab to streamline data pipeline workflow. In this dbt lesson, we will learn how to use the dbt compile command to generate executable SQL output for analysis and reviewing before creating tables. 📃More on dbt: docs.getdbt.com/reference/references-overview Show Support ☕ Paypal: www.paypal.me/jiejenn/5 ☕ Venmo: @Jie-J...
Documentation Generation in dbt | dbt Tutorial
zhlédnutí 96Před 21 dnem
dbt (Data Build Tool), a popular data transformation framework created by dbt Lab to streamline data pipeline workflow. In this dbt lesson, we will learn 1) how to generate dbt documentation site and 2) host the documentation site 📃More on dbt: docs.getdbt.com/reference/references-overview Show Support ☕ Paypal: www.paypal.me/jiejenn/5 ☕ Venmo: @Jie-Jenn 🌳 Patreon: www.patreon.com/JieJenn (ear...
Create Custom Generic Data Tests Using Macros | dbt Tutorial
zhlédnutí 69Před 21 dnem
dbt (Data Build Tool), a popular data transformation framework created by dbt Lab to streamline data pipeline workflow. In this dbt lesson, we will learn how to create macros to enhance the functionality of data testing. 📋Resource file: www.patreon.com/posts/resource-file-109579032 📃More on dbt: docs.getdbt.com/reference/references-overview Show Support ☕ Paypal: www.paypal.me/jiejenn/5 ☕ Venm...
Google Sheets Automation With App Script | Split A Worksheet & Delete Worksheets
zhlédnutí 145Před 21 dnem
In this video, I want to share two automation scripts that can make your workflow in Google Sheets more efficient. For the first script, we'll look at how to split a worksheet into multiple sheets based on a selected column. For the second script, we will create a procedure to delete all worksheets except the active sheet. These scripts can save you a lot of time and effort, especially when man...
Automate Data Testing With dbt | dbt Tutorial
zhlédnutí 190Před 28 dny
dbt (Data Build Tool), a popular data transformation framework created by dbt Lab to streamline data pipeline workflow. In this dbt lesson, we will learn 1) the difference between dbt singular and generic data tests, and 2) how how to create a singular data test and dbt built-in generic test. If you want to get into data engineering and data analytics, dbt is a must know subject. 📋 Resource Fil...
Create An Interactive Google Maps Screenshot Capture Desktop App In Python
zhlédnutí 347Před měsícem
The Google Maps Embed API allows you to easily embed Google Maps into your website or application. In this tutorial, I will show you how to create a desktop application with embedded Interactive Google Maps with screenshot feature using Python. Some of the common use cases for using the Google Maps Embed API such as display multiple store location, show real estate listings, event locations, or...
Google Cloud Video AI API Crash Course in Python | For Beginners
zhlédnutí 316Před měsícem
Video Intelligence is a powerful tool that brings advanced video analysis capabilities to your fingertips with ease. With Video Intelligence, you can automatically extract metadata from video content, making it easier to search, organize, and understand your video data. Throughout the tutorial, I will walk you through how to set up a Google Cloud project and share examples on how we can use vid...
Send Gmail Emails Using Google Cloud Function | Google Cloud Tutorial
zhlédnutí 456Před měsícem
In this tutorial, I will go through the steps on how to create a send an email using Gmail in Google Cloud Function. 📋Source Code: www.patreon.com/posts/source-code-send-108247150 📃 More on Google Cloud function: cloud.google.com/functions?hl=en Show Support ☕ Paypal: www.paypal.me/jiejenn/5 ☕ Venmo: @Jie-Jenn 🌳 Patreon: www.patreon.com/JieJenn (early access to tutorial source code) ✉️ Busines...
Load CSV Files To Database With "dbt seed" | dbt Tutorial
zhlédnutí 374Před měsícem
dbt (Data Build Tool), a popular data transformation framework created by dbt Lab to streamline data pipeline workflow. In this dbt lesson, we will learn how to use a very useful dbt command called "dbt seed" to upload CSV files to a database. If you want to get into data engineering and data analytics, dbt is a must know subject. Show Support ☕ Paypal: www.paypal.me/jiejenn/5 ☕ Venmo: @Jie-Je...
Getting Started With dbt (Data Build Tool) To Run Data Transformation | dbt Tutorial
zhlédnutí 384Před měsícem
Getting Started With dbt (Data Build Tool) To Run Data Transformation | dbt Tutorial
How to make a REST API call in Google Apps Script
zhlédnutí 327Před 2 měsíci
How to make a REST API call in Google Apps Script
Web Scraping Google Maps Using Playwright Python And OpenAI API
zhlédnutí 709Před 2 měsíci
Web Scraping Google Maps Using Playwright Python And OpenAI API
How To Download Files In Playwright Python | Browser Automation With Playwright Python
zhlédnutí 405Před 2 měsíci
How To Download Files In Playwright Python | Browser Automation With Playwright Python
Create Your Own OpenAI Whisper Speech-To-Text Desktop App Using Python (PyQt6)
zhlédnutí 380Před 2 měsíci
Create Your Own OpenAI Whisper Speech-To-Text Desktop App Using Python (PyQt6)
Create a translator LLM web app with LangChain and Python | LangChain Tutorial For Beginners
zhlédnutí 442Před 2 měsíci
Create a translator LLM web app with LangChain and Python | LangChain Tutorial For Beginners
Getting Started With Azure Maps API In 5 Minutes | Azure Tutorial For Beginners
zhlédnutí 1KPřed 2 měsíci
Getting Started With Azure Maps API In 5 Minutes | Azure Tutorial For Beginners
Create A Resource Group In Azure Portal Under 3 Minutes | Azure Tutorial For Beginners
zhlédnutí 76Před 2 měsíci
Create A Resource Group In Azure Portal Under 3 Minutes | Azure Tutorial For Beginners
Create An Azure Subscription In 3 Minutes | Azure Tutorial For Beginners
zhlédnutí 113Před 2 měsíci
Create An Azure Subscription In 3 Minutes | Azure Tutorial For Beginners
Web Scraping Websites Without Writing A Single Line Of Code
zhlédnutí 534Před 2 měsíci
Web Scraping Websites Without Writing A Single Line Of Code
Add Web Search Function To Your LangChain LLM Application With Tavily AI
zhlédnutí 400Před 2 měsíci
Add Web Search Function To Your LangChain LLM Application With Tavily AI
Connect Your LLM App Or RAG To The Web With Real-Time Content With Tavily AI Search API In Python
zhlédnutí 463Před 2 měsíci
Connect Your LLM App Or RAG To The Web With Real-Time Content With Tavily AI Search API In Python
Create Your Own YouTube AI Summarizer (& Transcript Downloader) Using Python and PyQt6
zhlédnutí 429Před 3 měsíci
Create Your Own CZcams AI Summarizer (& Transcript Downloader) Using Python and PyQt6
Turn Advanced Google Search Into A Desktop GUI App With Python and PyQt6
zhlédnutí 545Před 3 měsíci
Turn Advanced Google Search Into A Desktop GUI App With Python and PyQt6
Search The Web With Google Custom Search API In Python
zhlédnutí 1,5KPřed 3 měsíci
Search The Web With Google Custom Search API In Python
I've been trying to work on sending attachment file sizes that can go upto 100 mb using the graphClient APIs. The way i found is using UploadSession by creating one session, upload file, create a message and send it like that. The issue is even though i am trying to use the method, the upper cap is stuck at 30 mb somehow. Anything greater gives me an error saying "The message exceeds the maximum supported size., Cannot submit the message". I've a proper spring configuration for attaching files upto 250mb. Is there any other place that i need to check from azure maybe to increase or change this limit.
How can we schedule a data backup and download in the local storage automatically??
There are a few ways, window scheduler, cron, cloud scheduler, etc.
is it free
Only if you don't exceed the free usage.
Great work!
Bro really has everything
Really loved the video. Been adding my own tweaks to suit my needs. Changing it to keep track of my finances. As I dont want to pay for an api. I saw you have a gmail and google sheets api playlist? Would that be recommended to go through first? As there are somethings im watching that make more sense or helping me customize it a bit more
I was struggling so hard to get anywhere with Salesforce's documentation, like you said, it feels like there are steps missing! Thanks to your video I was able to actually get set up and start using the API.
Glad the video helped!
Do you have a tutorial about Forex? i need real time dollar index, canadian dollar index, japanese yen index, etc in google sheets
I don't unfortunately.
im not dev, was my first question how to change location :) TY your tuto work for an unitiated ! keep working
@jiejenn Great content! If you notice, initially when you checked the checkedbox manually, it was "x" but with pymupdf, it was a tick mark. Any possible way for getting "x" itself using PyMuPDF? I searched a lot, but couldnt find any solution for this.
Thanks pal. Now hoe use that token with GraphServiceClient, there need an TokenCredential object.
The Onedrive link to the exe is broken. Please fix the link.
Man you're a life saver!
👍👍👍
thanks
Although the paid api can only work with 25mb, but it also corrects and uses punctuation and stop marks , does this also work that way?
I believe so.
Is this paid? Do i have to pay something to azure to work with this API? i mean, i already pay for OneDrive, do i need to pay more?
API is free with unlimited API calls.
i am using AZURE free services for learning Do i need to pay for this services ?
Only you exceed the free quota limit.
@@jiejenn can you please tell me the limit ?
Good one
Hi jie, can you make a video of how can we get the latitude and longtitude from googles CID or address?
I will look into it.
@@jiejenn Thanks!
Please Make a video google map scraping with playwright without using AI or google map api.
How do you determine which scopes to use? Do they have to be added in oauth?
You will have to check the official documentation for the available scopes.
@jiejenn that's unclear because their are 23 scopes. How might I know which one(s) to use? The developers tool suggests not using them all so how might I know which scopes go with which tasks?
It was very useful, thank you very much good man!
did not work for me, it asked me to install playwright etc., can you help me please? I am using Windows 11 python 3.10
@@ibrahimosama5236 install playwright first.
I already installed playwright on my python environment. It is working. But when I package it. It doesn't work, it asks to install playwright again. Hope this makes sense
This resolved it for me if you are using visual studio code like me on windows, follow the same steps and this is the command to do the installation $env:PLAYWRIGHT_BROWSERS_PATH="0"; playwright install webkit thanks for the video man keep up the good work
I have an issue, "RuntimeWarning: Couldn't find ffmpeg or avconv - defaulting to ffmpeg, but may not work warn("Couldn't find ffmpeg or avconv - defaulting to ffmpeg, but may not work", RuntimeWarning)" do you know what it means?
You need to download FFMpeg binary first. You can Google it.
A very nice simple explanation. Thanks.
👍
What type of outlook mail app is that
What about a script to export my YT favorites and Watch later links to a text file. Has anyone made something like this?
Those two playlists are not available unfortunately.
Thank you!!!!
Taylor Michelle Hernandez Edward Taylor Thomas
good ...love this
this not working any one can help me.
how did you get through the 1000 post per minute limit?
You can bypass the rate limit using proxy.
Best,was looking for this
super helpful, thank you! The pyqt docu is not as good as I wish it was so videos like this are great!
Do you have a tutorial for appending data to a sharepoint list with python sir?
Unfortunately I don't have access to SharePoint.
I have a question. Everytime I run the script, it plays the audio, then saves the file. I would like to know if there is a way to still save the file, but not play the audio back
try remove audio_data attribute.
i literally cant get PyQt6 to work i follow the steps on their website, i use powershell and everything i have no bloody clue how to get this to work, and then they tell me python is easy
It gets Just in time for me. THANK youu
Great to hear!
Help
I need to pull dividend yield. How do i do that? Dividend yield is not an option.
Thanks brother .
You're a lifesaver fam, great video
Glad the video helped!
didnt work
@@cosvigil6970 okay.
Hey, can I download a large, townsized map in scale 1 : 20 using this?
Yeah, you should be able to. You can set the zoom in level in the URL.
How to load pipe delimiter file using dbt seed ?
Can you be more specific?
repo? pls
Thank you so much
This is amazing, thank you very much for showing us!
👍
imp_stats = ['wins','losses'] df.groupby('Ability')[imp_stats].mean().plot(kind='bar',figsize=(10,6)) plt.xlabel('Abilites') plt.ylabel('Total') plt.title('Wins and Looses according to Prestige') can this be also considered as the right way?
the 'embed' on right click doesn't show up for me as a family member on a account - any idea how to fix permissions to allow this? and then getting it to download via wget?
my workaround was to download it from onedrive, reupload to google drive, then share, modify properties to share with anyone who has the link, ensure view not edit, then use wget (or similar) with the link