Import Live Cryptocurrency Price (And More) In Google Sheets & Schedule Auto Refresh Jie Jenn 2026-09-20 | Import Live Cryptocurrency Price (And More) In Google Sheets & Schedule Auto Refresh
AWS Cloud Project | Create A YouTube Video Summary API With Lambda & API Gateway & OpenAI API Jie Jenn 2024-03-07 | This tutorial covers the steps to create a YouTube Video Summary API using AWS Lambda, API Gateway, and OpenAI's API. It is designed for individuals interested in combining serverless computing with AI to improve video content summarization. ⭐ What You Will Learn:➡ Create an AWS Lambda function to call 3rd party API➡ Set up API Gateway for your API.➡ Integrating OpenAI API for video summaries➡ Deployment and Testing: Steps to deploy and test your API.📺 Set up AWS API access: youtu.be/EX4ZuSAllCIResources:📑 AWS API Gateway Documentation: docs.aws.amazon.com/apigateway📑 AWS Lambda Documentation: docs.aws.amazon.com/lambda/?icmpid=docs_homepage_featuredsvcs📑 OpenAI API Guide: platform.openai.com/docs/tutorials📋 Source Code & download OpenAI zip file: wp.me/payCAw-1mH💖 Show Support☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn🌳 Patreon: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org0:00:00 Introduction to the project and its purpose.0:01:10 Demonstrating the API with a specific video example.0:03:00 Beginning the creation of the function in AWS Lambda.0:05:11 Utilizing the YouTube Transcript API for extracting transcripts.0:06:19 Overview and explanation of the Lambda function's source code.0:13:21 Testing the Lambda function with a sample event.0:18:11 Finalizing the Lambda function by adding necessary layers.0:20:16 Creating and configuring the API endpoint in API Gateway.0:24:59 Confirming the API's functionality with different video IDs.0:25:08 Concluding the tutorial and encouraging feedback.#aws #lambda #APIGateway #OpenAI #awsportfolioprojects #CloudComputing
Getting Started With Azure Document AI Document Intelligence API In Python (Source Code In Desc) Jie Jenn 2024-03-05 | Stop paying for expensive PDF to Text software, and to be honest, most of the free ones don't even work that well. Azure Document Intelligence is one of the AI services to build document processing solutions to analyze and extract information from your documents automatically. In this video we are going to learn how to use Azure’s Document AI Document Intelligence API in Python to extract data from tax forms like W2, 1099, invoices, receipts, and even bank statements. 📑 Source Code: wp.me/payCAw-1mC📙 PDF download source- housing.az.gov/documents-links/housing-invoices- kaggle.com/datasets/mcvishnu1/fake-w2-us-tax-form-dataset- kaggle.com/datasets/jenswalter/receipts💖 Show Support☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn🌳 Patreon: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro & agenda02:11 - Common use cases02:52 - Free tier & pricing info04:06 - Free tier limitations05:41 - Available Document Intelligence models07:10 - Install Azure Document Intelligence Python packages08:47 - Create & setup Azure Document Intelligence resource16:11 - Example 1: Tax Form (W2) data extraction36:18 - Example 2: Extract data from invoices45:02 - Example 3: Tables extraction#azure #python #ai
Getting Started With Groq API In Python (Running generative AI is more affordable than ever) Jie Jenn 2024-03-04 | Groq an AI chip startup company aiming to make running generative AI models affordable. In this tutorial, I will go through Groq API's pricing and how do use Groq API in Python.📋 Groq Pricing: wow.groq.com📋 Groq API Documentation: console.groq.com/docs/quickstart💖 Show Support☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn🌳 Patreon: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org 0:00:00 - Introduction to Groq AI API 0:00:58 - Pricing for different models 0:01:17 - Processing speed and model comparison 0:01:30 - API access request process 0:01:47 - API free access and model token limits 0:02:27 - Groq's API similarity to OpenAI's API 0:03:10 - Beginning of the tutorial: setting up the Groq Python package 0:03:40 - Creating a new API key 0:04:52 - Coding demonstration starts 0:07:44 - Review of request response and completion time 0:08:22 - Conclusion and final thoughts#groq #generativeai #python #genai
Create An Ollama Desktop App With Python & PyQt6 | Python GUI Application Jie Jenn 2024-02-29 | In this video, we are going to build an Ollama desktop app to run LLM models locally using Python and PyQt6.📑 Download resource files: wp.me/payCAw-1mA📃 Source Code: patreon.com/posts/source-code-app-99338920💻 Download Ollama: ollama.com💖 Show Support☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn🌳 Patreon: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro & App Demo & Feature Walkthrough03:52 - Benefits of desktop apps05:16 - Install Python dependencies06:48 - Helper modules08:11 - App development#python #ollama #pythonapp #desktopapplication
Create Your Own OpenAI GPT4 Vision AI Desktop App With Python | Python GUI Application Jie Jenn 2024-02-27 | In this tutorial, we will learn how to build an Vision AI Desktop Application using OpenAI API and Python. The OpenAI GPT4 Vision model is designed to broaden the applications of AI by integrating image processing capabilities alongside traditional text inputs. This development allows GPT-4 to understand and respond to images, making it more versatile and applicable to a wider range of use cases than ever before. And by incorporating GPT4 Vision model's capability in a desktop application, we can build a variety different utilities with ease.⭐Benefits of desktop app over web app⭐➡️ Performance: Desktop apps are generally faster as they can directly access computer hardware.➡️ Offline Access: They work without an internet connection.➡️ Faster development time: Because you don't have to worry about handling the web server, you can launch the desktop app with a single click.➡️ Security: Enhanced security since data is stored locally.➡️ Ease of Testing: You can test multiple models easily➡️ Customization: More control over application environment and customization.➡️ Compatibility: Fewer issues since they're developed for specific operating systems.➡️ Notifications: Can use system-level notifications for alerts.📋 Source Code: patreon.com/posts/source-code-your-99338505📺 Getting started with GPT4 Vision AI Model in Python: youtu.be/_1ujhANv6a4📋 More on GPT4 Vision Model: platform.openai.com/docs/guides/vision► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Demo & Agenda05:01 - Create Python Virtual Environment (Optional)06:00 - Install Python Dependencies06:34 - Desktop App Development#openai #gpt #gpt4 #python #ai #python
Python Web Scraping Real Estate Data For FREE Jie Jenn 2024-02-26 | In this video, I am going to show you how to use HomeHarvest Python library to download real estate data for free.► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#webscraping #webscraper #python
GCP Tutorial | Generate a Signed URL For Google Cloud Storage Files In Python Jie Jenn 2024-02-25 | The signed url is Google Cloud storage feature to grant temporary access to a private object in your Cloud Storage bucket to allow people to download or view a file without needing a gmail account or permission. In this tutorial, you are going to learn how to use Google Cloud Storage API to generate a signed url in Python.📋 More on Google Cloud (GCP): cloud.google.com/gcp► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#gcp #tutorial #googlecloud
AWS Tutorial | How to host a website for free using AWS S3 Jie Jenn 2024-02-22 | Learn how to host a static website on AWS S3 in just three easy steps with this tutorial. In this tutorial, I will cover everything from setting up your S3 bucket, configuring it for web hosting, to adjusting bucket policies for public access. Whether you're looking to host a simple site or explore the potential for passive income via Google ads, this video has you covered.► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#AWS #WebHosting #S3Tutorial #StaticWebsite #TechTutorial #AWSservices #S3
AWS Tutorial | Create a Python REST API with Lambda (Proxy Integration) and API Gateway For Free Jie Jenn 2024-02-20 | In this tutorial, we will learn how to create a REST API using AWS Lambda and API Gateway. This beginner-friendly guide introduces you to serverless computing with Lambda, demonstrating the ease of Lambda proxy integration, and how API Gateway serves as your API's front door. ⭐Topics I will be covering in this video:1. Introduction to AWS Lambda and API Gateway2. Overview of Serverless Computing3. Lambda Proxy vs. Non-Proxy Integration4. Setting Up an AWS Account5. Creating a Lambda Function6. Lambda Function Permissions and Execution Roles7. Configuring API Gateway8. Deploying the Hello World API9. Managing Request and Response Structures10. AWS Free Tier Pricing Overview11. Monitoring with AWS CloudWatch12. Best Practices for Organizing API Routes and Resources13. Deploying the API to Different Stages14. Troubleshooting Common Issues15. Conclusion and Next Steps📃 More info on AWS Lambda: aws.amazon.com/lambda📃 More info on AWS API Gateway: aws.amazon.com/api-gateway► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro to Lambda Proxy Integration and API Gateway01:32 - Lambda and API Gateway Pricing + Free Tier usage03:26 - Exercise demo05:40 - Create HelloWorld Lambda function07:44 - Lambda timeout and memory configuration08:50 - API Gateway: Create API10:37 - API Gateway: Create Resource#apigateway #lamda #aws #restapi #python
Automate AWS S3 Access with Presigned URLs using Python Jie Jenn 2024-02-18 | In this tutorial, I am going to show you how to generate S3 object presigned url using Python.A presigned URL in the context of AWS S3 (Simple Storage Service) is a URL that provides temporary access to a private object stored in an S3 bucket. It's "signed" because it includes a signature in the query parameters that is calculated using your AWS credentials.► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#aws #awss3 #boto3
Run Ollama On Windows Using Docker For Python Development Jie Jenn 2024-02-18 | In this video I will go through the details on how to run Ollama using Docker on a Windows PC for Python development.📋 Download Docker Desktop: docker.com/products/docker-desktop📋 Ollama model List: ollama.com/library📋 Llama 2 model download: ollama.com/library/llama2► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#ollama #python #pythonai
How To Change Ollama Model Default Directory Jie Jenn 2024-02-17 | In this quick video, I will go through the steps how to change the default directory location when you download an Ollama model.► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#ollama
Install Ollama on Windows For Python Development Jie Jenn 2024-02-17 | Ollama just released the Window's version. In this video I will go through the installation and how to connect to Ollama in Python.📋 Download Ollama: ollama.com► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Ollama Intro & Installation01:49 - Download Ollama model03:42 - Install Ollama Python library06:10 - Ollama Desktop App Demo Preview#ollama #python #pythonai
Upload Files To OpenAI Files Repo From S3 Using Python Jie Jenn 2024-02-16 | In this video, I am going to show you how to upload files from your S3 bucket to OpenAI files repository using Python.⭐ Resources ⭐📋 OpenAI Files API Reference: platform.openai.com/docs/api-reference/files► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ PayPal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#openaiapi #openai #python
Create An AI Assistant Chatbot With RAG Capability With OpenAI Assistants API & Python Jie Jenn 2024-02-13 | Learn how to build an AI Chatbot with RAG capability from scratch using OpenAI's Assistants API in Python. In this tutorial, I will walk you through each step from creating a Python virtual environment all the way to developing your own AI chatbot.📃 openai_utility.py source code: wp.me/payCAw-1mu⭐ Resources ⭐📋 Getting started with Assistants API: youtu.be/zxQpOdgfI_Q📋 Manage OpenAI Files (RAG): youtu.be/-hT5GgcB2Mk📋 OpenAI Assistants API Reference: platform.openai.com/docs/api-reference/assistants► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ PayPal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro & agenda02:24 - App demo04:58 - Create a Python virtual environment (optional)05:54 - Dive into chatbot script development#openaiapi #openai #python #chatbotdevelopment
Create A Reddit Scraper Without API Key Using Python Jie Jenn 2024-02-11 | Reddit, a platform where millions of people share their ideas, opinions, and questions about anything. It’s also a data gold mine for data analytics, trend analysis, and market research. In this tutorial, I will show you how to scrape reddit data without using Reddit API access key in Python.Source Code: ► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#webscraping #python #reddit
Convert Text To Real Human Speech With Google Cloud Text-To-Speech API In Python Jie Jenn 2024-02-08 | Google Text-to-Speech is a cloud service by Google that turns text into natural-sounding speech. Using advanced machine learning, it offers a variety of voices and languages, making digital content more engaging and accessible to a wide audience. In this tutorial, we are going to learn how to get started with Google Cloud Text To Speech API in Python.📋 Voice List: cloud.google.com/text-to-speech/docs/voice-types📋 GCP Text-To-Speech Pricing: cloud.google.com/text-to-speech/pricing► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro & Demo02:44 - Pricing03:56 - Create a Google Cloud project (optional)05:05 - Enable GCP Text-To-Speech API05:35 - Create a service account08:25 - Text-To-Speech Python script development#gcp #googlecloud #python #texttospeech
Create Your Own GPT AI Assistant With OpenAI API In Python Jie Jenn 2024-02-06 | In this tutorial, we are going to learn how to build your own AI Assistant using OpenAI Assistants API in Python.The Assistant API is one of the newest APIs released by OpenAI, designed to enables developers to easily build powerful AI assistants within their apps. With the Assistants API, it removes the need to manage conversation history by using persistent threads, and adds access to OpenAI-hosted tools like Code Interpreter, function calling, and knowledge retrieval.📋 Signup for OpenAI: openai.com📋 OpenAI API Pricing: openai.com/pricing📑 OpenAI API Reference: platform.openai.com/docs/api-reference► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Overview & agenda00:50 - API components02:17 - Script development03:07 - Step 1: Create an Assistant template06:35 - Step 2: Create an assistant thread07:42 - Step 3: Create a message thread09:54 - Step 4: Send message to the assistant thread11:53 - Step 5: Check message thread session status12:10 - Step 6: Display Assistant's response14:17 - Step 7: Ask follow up questionlearn the basic of building your own AI assistant.#openai #openaiapi #python
Manage OpenAI Files (RAG) With OpenAI Files API In Python | Tutorial For Beginners Jie Jenn 2024-02-04 | In this OpenAI tutorial, we are going to learn how to manage Files hosted on OpenAI using Files API in Python.The OpenAI Files API is probably one of the most important API to know if you want build a sophisticated and capable AI Assistant model, or if you want to provide documents to enhance existing GPT models.📋 Signup for OpenAI: openai.com📋 OpenAI API Pricing: openai.com/pricing► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro to OpenAI Files API00:35 - Files API pricing02:45 - Files API examples (Python)04:13 - Example: Upload a file08:33 - Example: List files hosted on OpenAI's server10:06 - Example: Upload multiple files11:46 - Example: Retrieve a file12:06 - Example: Delete a file12:35 - Empty OpenAI file repo#openai #openaiapi #filesapi #python #aiassistant #finetuning
Account Alias To Hide Your AWS Account ID | AWS Tutorial Jie Jenn 2024-02-04 | In this quick tutorial, I will walk through how to change the account id display on the AWS console manage.📋 More info on AWS: aws.amazon.com► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#aws #awstraining #awstutorialforbeginners
Image Analysis With OpenAI API GPT4 Vision In Python Jie Jenn 2024-02-01 | So GPT4 Vision model is a new model OpenAI released recently to compete with Google’s Gemini AI model to give people the capability to analyze images. In this tutorial, we will learn how to analyze images using GPT4 Vision model in Python.📋 Signup for OpenAI: openai.com► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - GPT4 Vision Model Intro & Agenda02:05 - API Key setup04:07 - Example 1: Analyze image from the web10:58 - Example 2: Analyze image from a local file12:23 - Example 3: Extract image content15:40 - Example 4: Analyze multiple images#openai #openaiapi #gpt4 #python
Getting Started With AWS CloudFormating For Beginners Jie Jenn 2024-01-30 | CloudFormation is an AWS service that automates the setup, management, and scaling of AWS resources using templates, and CloudFormation in my opinion, is probably one of the most important skill to know if you work with AWS, especially if you work as an Cloud engineer or a system admin.In this tutorial, we are going to learn how to use CloudFormation in AWS to deploy S3 buckets.📋 More info on AWS CloudFormation: aws.amazon.com/cloudformation📋 AWS CloudFormation Resource and Property Types Reference: docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-template-resource-type-ref.html📋 AWS CloudFormation Template Snippets: docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/CHAP_TemplateQuickRef.html📋 AWS CloudFormation Version: docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/format-version-structure.html► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro to AWS CloudFormation02:03 - CloudFormation Example: JSON vs YAML04:02 - Exercise: Create a CloudFormation Template to create S3 buckets#aws #cloudformation #awstraining
Turn Your Text Into Realistic Human Speech With OpenAI Speech-To-Text API In Python Jie Jenn 2024-01-28 | In this tutorial, we are going to learn how to use OpenAI Text To Speech API to convert text to human like audio in Python.📋 OpenAI Pricing: openai.com/pricing📋 OpenAI Text-To-Speech Voice Options: platform.openai.com/docs/guides/text-to-speech/voice-options📋 Sign up for OpenAI: openai.com📺 OpenAI Speech-To-Text tutorial: youtu.be/RH1lGKVGLx0► Buy Me a Coffee? Your support is much appreciated-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#openai #openaiapi #texttospeech #python
Turn Your Audio Into Text With OpenAI Speech-To-Text API In Python Jie Jenn 2024-01-27 | In this tutorial, we are going to learn how to use OpenAI Speech-To-Text API to convert your audio files into text.📋 OpenAI Pricing: openai.com/pricing📋 Sign up for OpenAI: openai.com📺 OpenAI Text-To-Speech Tutorial: youtu.be/4XI85_wwcIo► Buy Me a Coffee? Your support is much appreciated-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#openai #openaiapi #speechtotext #python
Getting Started With Microsoft ToDo App API In Python | Tutorial For Beginners Jie Jenn 2024-01-24 | Microsoft To Do is a task management app by Microsoft that allows users to create to-do lists, set reminders, and organize tasks. It integrates with other Microsoft products like Outlook for streamlined task management. In this tutorial, we will learn how to use Microsoft Graph API to automate Microsoft ToDo App in Python.This is going to be a beginner friendly tutorial, I will cover every single step from setting up an Azure app, all the way to putting together a Python script to return my to do list items.📋 More info on Microsoft Graph API: developer.microsoft.com/en-us/graph/rest-api📋 More info on Microsoft Azure: azure.microsoft.com/en-us► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro To Microsoft ToDo App API01:17 - Create an Azure App03:34 - Generate client secret05:01 - Set Azure App permission06:00 - Python script development#azire #todoapp #microsofttodo #python
AWS Tutorial | Getting Started With AWS Redshift Date Warehouse For Beginners Jie Jenn 2024-01-23 | AWS Redshift (Amazon Redshift) is a fully managed, petabyte-scale data warehouse service provided by Amazon Web Services. It offers a serverless option, eliminating the need to manage server resources and allowing for automatic scaling to handle large-scale data sets and complex queries using SQL. This serverless capability enables fast, efficient data analysis and easy handling of varying workloads.📋 More info on AWS Redshift: aws.amazon.com/redshift► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro to (AWS Redshift) Amazon Redshift00:57 - AWS Redshift Data Warehosue configuration01:19 - Load data04:53 - Query data10:01 - Delete Redshift instance#redshift #aws #amazonredshift #cloud #cloudcomputing
Part 2 - Parse Data Points With BeautifulSoup | Web Scraping Zillow Data With Playwright In Python Jie Jenn 2024-01-21 | In this tutorial, we are going to dive into the development of how to use Playwright and Python to web scrape Zillow's website to collect data for market research analysis, property analysis and a few other things.📺 Part 1: youtu.be/1WMLgOScAhE📋 Playwright For Python Reference: https://playwright.dev/python/docs/api/class-playwright► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#zillow #webscraping #webscraper #python
Part 1 - Download Page HTMLs | Web Scraping Zillow Data With Playwright In Python Jie Jenn 2024-01-21 | In this tutorial, we are going to dive into the development of how to use Playwright and Python to web scrape Zillow's website to collect data for market research analysis, property analysis and a few other things.📺 Part 2: youtu.be/JqQxkOI6mU4📋 Playwright For Python Reference: https://playwright.dev/python/docs/api/class-playwright► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#zillow #webscraping #webscraper #python
How To Track AWS Free Tier Usage In AWS Console Jie Jenn 2024-01-19 | One of the worst things can happen to AWS user is running out AWS free service quota without realizing. In this quick video, I will go over how to track AWS free tier usage in AWS console.📋 More information on track AWS free tier usage: docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/tracking-free-tier-usage.html► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#aws #awstraining #awstraining
AWS Tutorial | Query S3 Data With AWS Athena | Tutorial For Beginners Jie Jenn 2024-01-19 | In this tutorial, we will learn how to use Amazon Athena to write SQL query to query data files from a S3 bucket.Amazon Athena is an serverless query service that makes it easy to analyze data directly in S3 using standard SQL. It is designed to be easy to use, with no infrastructure to manage, and you pay only for the queries you run. Using Amazon Athena, we can directly analyzing large datasets in scenarios like log analysis, generating business reports, and real-time data analysis. 📑 Download sample Sales Data file: drive.google.com/file/d/1VHyZivJgsU6Y1Tv28kuKY0rX-pa3xb5u/view?usp=sharing📋 More information on AWS Athena: aws.amazon.com/athena► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro to AWS Athena00:42 - Navigate to AWS Athena00:54 - Create a workgroup02:56 - Create S3 buckets04:33 - Link S3 bucket to store query exports05:25 - Create a database05:56 - Create AWS Athena S3 tables#aws #awscloud #cloud #cloudcomputing
Azure Tutorial | Web Search With Microsoft Bing Search API In Python Jie Jenn 2024-01-17 | The Microsoft Bing Search API is service provided by Microsoft Azure to search contents on the web programmatically. Some of the things you can do with Bing Search API such as market research analysis, content discovery, SEO, data collections, and brand monitoring. Throughout the tutorial, I will cover how to create a Resource Group, add Bing Search API to the resource group, and how to use Bing Search API to run web and image search in Python.📑Sign up for Azure: azure.microsoft.com📑 Azure Bing Search API Pricing: microsoft.com/en-us/bing/apis/pricing📋 Bing Web Search API endpoint: api.bing.microsoft.com/v7.0/search📋 Bing Image Search API endpoint: api.bing.microsoft.com/v7.0/images/search► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro To Microsoft Bing API00:48 - Azure Bing Search API pricing02:01 - Create a resource group03:00 - Add Bing Search Resource04:53 - Bing API Python package installation05:05 - Generate Bing API access key05:44 - Bing Search Python script development#azure #bing #bingsearch #cloudcomputing
SQL Tutorial | Solve A Difficult SQL Interview Problem For Job Interviews | #10355 Jie Jenn 2024-01-15 | Job market is tough these days, even for data analysts and data engineers. The best way to really impress and get a job is by acing those technical SQL interview questions. In this tutorial, I will walk you through the process of solving a hard level difficulty SQL interview question.Whether you are a beginner or an experienced professional, this video will provide you with the knowledge and skills you need to excel in your interview. By the end of this tutorial, you'll be able to confidently answer any SQL question that comes your way and impress your interviewer. 📗 Question Link: platform.stratascratch.com/coding/10355-employees-with-same-birth-month?code_type=5&via=jie📗 More SQL questions on Stratascratch @ stratascratch.com/?via=jie► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#sql #sqlinterview #sqlserver #stratascratch
SQL Tutorial | Solve A Difficult SQL Interview Problem For Job Interviews | #10314 Jie Jenn 2024-01-14 | Job market is tough these days, even for data analysts and data engineers. The best way to really impress and get a job is by acing those technical SQL interview questions. In this tutorial, I will walk you through the process of solving a hard level difficulty SQL interview question.Whether you are a beginner or an experienced professional, this video will provide you with the knowledge and skills you need to excel in your interview. By the end of this tutorial, you'll be able to confidently answer any SQL question that comes your way and impress your interviewer. 📗 Question Link: platform.stratascratch.com/coding/10314-revenue-over-time?code_type=5&via=jie📗 More SQL questions on Stratascratch @ stratascratch.com/?via=jie► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#sql #sqlinterview #sqlserver #stratascratch
Getting Started With AWS EC2 (Key Pair, Security Group, EC2 Instance Setup) | Tutorial For Beginner Jie Jenn 2024-01-12 | AWS Elastic Compute Cloud, commonly known as AWS EC2. With AWS EC 2, we can host web applications, game servers, and websites, run data processing jobs, or create a separate environment for script development. Through out the lesson I will walk you through how to create a key pair, set up a security group, and create, connect, terminate an EC2 instance using the free tier configuration.📋 More information on AWS EC 2: aws.amazon.com/pm/ec2► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro to AWS EC200:45 - Create Key Pair02:02 - Create and Configure Security Group04:42 - Create & setup an EC2 instance07:45 - Connect to an EC2 instance09:38 - Terminate an EC2 instance#ec2 #cloud #aws #awsec2 #tutorial
AWS Tutorial | How To Add External Python Libraries To An AWS Lambda Function (Python Runtime) Jie Jenn 2024-01-10 | One thing I noticed many new AWS lambda (Python runtime) users have is trying to figure out how to add external Python libraries. In this tutorial, we will learn how to add external Python libraries to your lambda function.📋 More information on AWS Lambda function: aws.amazon.com/lambda► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#python #lambda #awslambda
How To Package Your Playwright Python App With Pyinstaller Jie Jenn 2024-01-09 | Packing a Python Playwright app can be a little bit tricky, so I thought I put together a quick walkthrough to show you how to package a Python Playwright App using Pyinstaller.📋 More info on Playwright For Python: https://playwright.dev/python/docs/api/class-playwright► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#playwright #python
How To Solve A Medium Difficulty SQL Interview Problem For Job Interview | #10163 Jie Jenn 2024-01-07 | Job market is tough these days, even for data analysts and data engineers. The best way to really impress and get a job is by acing those technical SQL interview questions. In this tutorial, I will walk you through the process of solving a medium level difficulty SQL interview question.Whether you are a beginner or an experienced professional, this video will provide you with the knowledge and skills you need to excel in your interview. By the end of this tutorial, you'll be able to confidently answer any SQL question that comes your way and impress your interviewer. 📗 Question Link: platform.stratascratch.com/coding/10163-product-transaction-count?code_type=5&via=jie📗 More SQL questions on Stratascratch @ stratascratch.com/?via=jie► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#sql #sqlinterview #sqlserver #stratascratch
How To Solve A Medium Difficulty SQL Interview Problem For Job Interview | #10310 Jie Jenn 2024-01-06 | Job market is tough these days, even for data analysts and data engineers. The best way to really impress and get a job is by acing those technical SQL interview questions. In this tutorial, I will walk you through the process of solving a medium level difficulty SQL interview question.Whether you are a beginner or an experienced professional, this video will provide you with the knowledge and skills you need to excel in your interview. By the end of this tutorial, you'll be able to confidently answer any SQL question that comes your way and impress your interviewer. 📗 Question Link: platform.stratascratch.com/coding/10310-class-performance?code_type=5&via=jie📗 More SQL questions on Stratascratch @ stratascratch.com/?via=jie► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#sql #sqlinterview #sqlserver #stratascratch
Create Your Own AI Chatbot With Google Gemini AI API Using Python Jie Jenn 2024-01-04 | Discover how to build your own AI chatbot in this step-by-step tutorial using Python and Google Gemini AI API. Perfect for developers interested in AI, machine learning, and chatbot technology, this comprehensive guide will walk you through the process of integrating Google's generativeai API and Gemini AI model to create a responsive and intelligent chatbot. Whether you're a beginner or an experienced Python developer, you'll gain valuable insights into AI chatbot development, leveraging Google Cloud's powerful tools. Don't miss out on this opportunity to enhance your programming skills and delve into the fascinating world of AI chatbots. Subscribe for more tech tutorials and hit the bell icon to stay updated!📋 Google AI Studio: makersuite.google.com/app/prompts/new_freeform📑 Google Generative AI API Reference: https://ai.google.dev/api/python/google/generativeai► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org0:00 - Introduction0:02 - Overview: Building a Gemini AI Chatbot0:14 - Launching and Demonstrating the App0:24 - Using Google's Generative AI Python Library0:38 - Example Interaction with Gemini AI0:47 - Response Demonstration: Location of Chicago1:02 - Discussing Output Format Options1:18 - Tutorial Scope and Advanced Features1:33 - Setting Up Python Virtual Environment2:04 - Command for Creating Python Virtual Environment2:13 - Naming the Environment and Preparations2:25 - Accessing API Key and Setting up Google Cloud3:00 - Google Cloud Account and API Key Generation3:17 - Creating and Configuring API Key4:03 - Starting Script Development4:48 - Writing and Organizing Code for Chatbot5:41 - Implementing Chatbot Functions and Methods6:03 - Configuring Gen-AI Module and API Key6:57 - Setting Up Chatbot Model and Session7:49 - Preloading Conversation History8:24 - Starting and Managing Chatbot Conversations9:01 - Handling Chatbot Outputs and Responses9:54 - Adjusting Configuration and Response Settings10:09 - Testing and Interacting with the Chatbot11:35 - Changing Output Formats and Concluding Tutorial12:01 - Final Remarks and Source Code Availability#AIChatbot #GoogleGeminiAI #PythonTutorial #MachineLearning #GoogleCloud #Programming #TechTutorial #GoogleAPI #ChatbotDevelopment #ArtificialIntelligence
Web Scraping Top Cryptocurrencies With Python | Web Scraping Exercise For Beginners Jie Jenn 2024-01-01 | In this tutorial, we are going to do a simple web scraping exercise to scrape top ranked cryptocurrencies from livecoinwatch.com using Python.► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org
How To Solve A Difficult SQL Question For Job Interview | #10359 Jie Jenn 2023-12-29 | Job market is tough these days, even for data analysts and data engineers. The best way to really impress and get a job is by acing those technical SQL interview questions. In this tutorial, I will walk you through the process of solving a hard level difficult SQL interview question.Whether you are a beginner or an experienced professional, this video will provide you with the knowledge and skills you need to excel in your interview. By the end of this tutorial, you'll be able to confidently answer any SQL question that comes your way and impress your interviewer. 📗 Question Link: platform.stratascratch.com/coding/10359-eligible-employees?code_type=5&via=jie📗 More SQL questions on Stratascratch @ stratascratch.com/?via=jie► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#sql #sqlinterview #sqlserver #stratascratch
How To Solve A Difficult SQL Question For Job Interview | #10358 Jie Jenn 2023-12-28 | Job market is tough these days, even for data analysts and data engineers. The best way to really impress and get a job is by acing those technical SQL interview questions. In this tutorial, I will walk you through the process of solving a hard level difficult SQL interview question.Whether you are a beginner or an experienced professional, this video will provide you with the knowledge and skills you need to excel in your interview. By the end of this tutorial, you'll be able to confidently answer any SQL question that comes your way and impress your interviewer. 📗 Question Link: platform.stratascratch.com/coding/10358-friday-purchases?code_type=5&via=jie📗 More SQL questions on Stratascratch @ stratascratch.com/?via=jie► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#sql #sqlinterview #sqlserver #stratascratch
Upload Data Files To Any Database Without Writing A Single Line Of SQL Using Python Jie Jenn 2023-12-26 | As someone who works extensively with data engineering and web scraping, I constantly have to upload different datasets directly to different databases based on the database my clients are using.In this tutorial, I am going to share how I use sqlalchemy, pandas to upload raw data files to a database system with ease in Python.📋 SQLAlchemy Supported Data Type Reference: docs.sqlalchemy.org/en/20/core/types.html► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#pandas #python #database
Getting Started With Google Gemini AI Python Library | Step-By-Step Tutorial Jie Jenn 2023-12-26 | In this tutorial, we will learn how to use Google's official Python google-generativeai Python library to work with Gemini AI API.📋 More information on google-generativeai Python module: https://ai.google.dev/docs📋 How to get started with Vertex AI Python SDK to use Gemini AI model: youtu.be/tCpGtGKZKQc▶▶ Prerequisites- Python 3.9+► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Intro to Google Generative AI Python Client01:17 - Create a Python Virtual Environment01:53 - Install Google Generative AI Python SDK02:07 - Create API key04:10 - Gemini Python exercises#geminiai #python
Getting Started With AWS SQS To Streamline Your Workflow | Tutorial For Beginners Jie Jenn 2023-12-19 | In this tutorial, we'll learn how to use AWS SQS to stream your workflow from scratch.AWS SQS, which stands for Amazon Web Services Simple Queue Service, is a robust, cloud-based message queuing service, designed to enhance the efficiency and scalability of your business applications.By incorporating SQS into your application, you can streamline your workflow by managing tasks that don't need to be processed immediately, allowing for better resource allocation and efficiency. 📋 More information on AWS SQS: aws.amazon.com/sqs📋 Standard Queue Quotas: docs.aws.amazon.com/AWSSimpleQueueService/latest/SQSDeveloperGuide/quotas-queues.html📋 FIFO Queue Quotas: docs.aws.amazon.com/AWSSimpleQueueService/latest/SQSDeveloperGuide/quotas-fifo-queues.html► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org0:00 - Introduction to the Tutorial0:02 - Overview of AWS SQS and Its Benefits0:08 - Explanation of Amazon AWS SQS0:21 - Streamlining Workflow with SQS0:36 - ETL Process Management with SQS0:47 - Overview of SQS Pricing1:38 - Personal Experience with SQS in ETL Pipelines2:00 - Additional Costs: Data Transfer Usage2:05 - Starting the SQS Tutorial2:10 - Signing Up for AWS and Searching for SQS2:29 - Understanding and Creating Queues in SQS2:46 - Queue Types: Standard and FIFO Queue3:17 - Choosing the Right Queue Type for Your Needs4:07 - Queue Creation and Naming4:26 - Queue Configuration Settings5:14 - Encryption and Access Policy for Queues5:56 - Creating and Configuring Additional Queues6:31 - Understanding Redrive Allow Policy and Dead Letter Queue7:12 - Queue Attributes and Message Filtering7:56 - Sending Messages to the Queue9:31 - Sending and Receiving Messages in SQS10:36 - Retrieving and Analyzing Messages11:43 - Message Details and Attributes12:30 - Managing Message Visibility and Queue Refresh13:05 - Processing Messages and Message Visibility13:30 - Emptying and Managing the Queue13:56 - Conclusion and Introduction to Upcoming Tutorial#aws #sqs #gettingstarted #tutorial #cloud
Real World Example Using Google Gemini Pro Vision AI Model API In Python Jie Jenn 2023-12-17 | Unlike ChatGPT, Google Gemini model has the ability to read both video and image files, and requires less computational power. In this tutorial, I am going to cover 6 examples on how we can use Gemini Pro Vision AI in Python to help with our daily task.📺 Getting Started With Google Gemini AI API in Python: youtu.be/tCpGtGKZKQc📋 Sign up for Google Cloud: cloud.google.com📋 Gemini API Info: cloud.google.com/vertex-ai/docs/reference► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Examples I will be covering01:51 - Create a story from a photo06:27 - Analyze a video with Gemini Vision Pro AI09:19 - Create a tourism ad based on a video11:02 - Figure out a price of a good using an image13:36 - Output product prices in a photo in JSON format 16:24 - Transcribe a hand-written letter from a photo#gemini #googlegemini #googlecloud #python
Getting Started With Google Gemini API In Python (Vertex AI) | Full Tutorial Jie Jenn 2023-12-14 | Google recently just announced the release of Gemini Generative AI model on their Vertex AI platform. In this tutorial, I will walk you through each step on how to get started using Gemini API in Python.📺 Real World Examples Using Google Gemini Pro Vision AI model in Python: youtu.be/mSJa3tQc4xk📋 Sign up for Google Cloud: cloud.google.com📋 Gemini API Info: cloud.google.com/vertex-ai/docs/reference► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Into to Google Gemini00:22 - Gemini API pricing00:52 - Tutorial starts01:16 - Create a Google Cloud Service Account03:34 - Create environment variable for authentication04:26 - Python script development (Gemini API exercise)#gemini #googlegemini #googlecloud #python
Download Live Crypto Pricing Data In Excel With LiveCoinWatch API (Its FREE) Jie Jenn 2023-12-13 | We know Excel's financial data type feature doesn't really support Crypto currencies very well, so I thought I would share an alternative to import crypto data from the web in Excel.💻 LiveCoinWatch Website: livecoinwatch.com📄 Source Code: wp.me/payCAw-1mo► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#excel #crypto #bitcoin #cryptocurrency
Ace A Difficult SQL Interview Question For Data Analysts And Data Engineers | Meta #2007 Jie Jenn 2023-12-10 | Job market is tough these days, even for data analysts and data engineers. The best way to really impress and get a job is by acing those technical SQL interview questions. In this tutorial, I will walk you through the process of solving a SQL interview question by Meta (Facebook). Whether you are a beginner or an experienced professional, this video will provide you with the knowledge and skills you need to excel in your interview. By the end of this tutorial, you'll be able to confidently answer any SQL question that comes your way and impress your interviewer. 📗 Question Link: platform.stratascratch.com/coding/2007-rank-variance-per-country?code_type=5&via=jie📗 More SQL questions on Stratascratch @ stratascratch.com/?via=jie► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org#sql #sqlinterview #sqlserver
Set Up AWS User Authentication For Python Development | Step-By-Step Tutorial Jie Jenn 2023-12-07 | In this tutorial, we will learn how to set up AWS credentials for Python development. This setup is essential for interacting with AWS services using Python, specifically through the Boto3 library.📑 AWS Doc: docs.aws.amazon.com► Buy Me a Coffee? Your support is much appreciated!-------------------------------------------------------------------------------------------☕ Paypal: paypal.me/jiejenn/5☕ Venmo: @Jie-Jenn💸 Join Robinhood with my link and we'll both get a free stock: bit.ly/3iWr7LC► Support my channel so I can continue making free contents---------------------------------------------------------------------------------------------------------------🛒 By shopping on Amazon → amzn.to/2JkGeMD👩💻 Follow me on Linked: linkedin.com/in/jiejenn🌳 Becoming a Patreon supporter: patreon.com/JieJenn✉️ Business Inquiring: YouTube@LearnDataAnalysis.org00:00 - Create users02:26 - set up profile in user directory06:03 - use a different profile06:57 - provide the user credential access key manually#aws #awstrainingvideos #awstraining
