Create Your Own AI Chatbot With Google Gemini AI API Using Python @jiejenn

Jie Jenn 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.org

0:00 - Introduction
0:02 - Overview: Building a Gemini AI Chatbot
0:14 - Launching and Demonstrating the App
0:24 - Using Google's Generative AI Python Library
0:38 - Example Interaction with Gemini AI
0:47 - Response Demonstration: Location of Chicago
1:02 - Discussing Output Format Options
1:18 - Tutorial Scope and Advanced Features
1:33 - Setting Up Python Virtual Environment
2:04 - Command for Creating Python Virtual Environment
2:13 - Naming the Environment and Preparations
2:25 - Accessing API Key and Setting up Google Cloud
3:00 - Google Cloud Account and API Key Generation
3:17 - Creating and Configuring API Key
4:03 - Starting Script Development
4:48 - Writing and Organizing Code for Chatbot
5:41 - Implementing Chatbot Functions and Methods
6:03 - Configuring Gen-AI Module and API Key
6:57 - Setting Up Chatbot Model and Session
7:49 - Preloading Conversation History
8:24 - Starting and Managing Chatbot Conversations
9:01 - Handling Chatbot Outputs and Responses
9:54 - Adjusting Configuration and Response Settings
10:09 - Testing and Interacting with the Chatbot
11:35 - Changing Output Formats and Concluding Tutorial
12:01 - Final Remarks and Source Code Availability

#AIChatbot #GoogleGeminiAI #PythonTutorial #MachineLearning #GoogleCloud #Programming #TechTutorial #GoogleAPI #ChatbotDevelopment #ArtificialIntelligence

updated 2 years ago

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.org

0:00 - Introduction
0:02 - Overview: Building a Gemini AI Chatbot
0:14 - Launching and Demonstrating the App
0:24 - Using Google's Generative AI Python Library
0:38 - Example Interaction with Gemini AI
0:47 - Response Demonstration: Location of Chicago
1:02 - Discussing Output Format Options
1:18 - Tutorial Scope and Advanced Features
1:33 - Setting Up Python Virtual Environment
2:04 - Command for Creating Python Virtual Environment
2:13 - Naming the Environment and Preparations
2:25 - Accessing API Key and Setting up Google Cloud
3:00 - Google Cloud Account and API Key Generation
3:17 - Creating and Configuring API Key
4:03 - Starting Script Development
4:48 - Writing and Organizing Code for Chatbot
5:41 - Implementing Chatbot Functions and Methods
6:03 - Configuring Gen-AI Module and API Key
6:57 - Setting Up Chatbot Model and Session
7:49 - Preloading Conversation History
8:24 - Starting and Managing Chatbot Conversations
9:01 - Handling Chatbot Outputs and Responses
9:54 - Adjusting Configuration and Response Settings
10:09 - Testing and Interacting with the Chatbot
11:35 - Changing Output Formats and Concluding Tutorial
12:01 - Final Remarks and Source Code Availability

#AIChatbot #GoogleGeminiAI #PythonTutorial #MachineLearning #GoogleCloud #Programming #TechTutorial #GoogleAPI #ChatbotDevelopment #ArtificialIntelligence

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/EX4ZuSAllCI

Resources:
📑 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.org

0: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.org

00:00 - Intro & agenda
02:11 - Common use cases
02:52 - Free tier & pricing info
04:06 - Free tier limitations
05:41 - Available Document Intelligence models
07:10 - Install Azure Document Intelligence Python packages
08:47 - Create & setup Azure Document Intelligence resource
16:11 - Example 1: Tax Form (W2) data extraction
36:18 - Example 2: Extract data from invoices
45: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.org

00:00 - Intro & App Demo & Feature Walkthrough
03:52 - Benefits of desktop apps
05:16 - Install Python dependencies
06:48 - Helper modules
08: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.org

00:00 - Demo & Agenda
05:01 - Create Python Virtual Environment (Optional)
06:00 - Install Python Dependencies
06: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 Gateway
2. Overview of Serverless Computing
3. Lambda Proxy vs. Non-Proxy Integration
4. Setting Up an AWS Account
5. Creating a Lambda Function
6. Lambda Function Permissions and Execution Roles
7. Configuring API Gateway
8. Deploying the Hello World API
9. Managing Request and Response Structures
10. AWS Free Tier Pricing Overview
11. Monitoring with AWS CloudWatch
12. Best Practices for Organizing API Routes and Resources
13. Deploying the API to Different Stages
14. Troubleshooting Common Issues
15. 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.org

00:00 - Intro to Lambda Proxy Integration and API Gateway
01:32 - Lambda and API Gateway Pricing + Free Tier usage
03:26 - Exercise demo
05:40 - Create HelloWorld Lambda function
07:44 - Lambda timeout and memory configuration
08:50 - API Gateway: Create API
10: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.org

00:00 - Ollama Intro & Installation
01:49 - Download Ollama model
03:42 - Install Ollama Python library
06: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.org

00:00 - Intro & agenda
02:24 - App demo
04: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.org

00:00 - Intro & Demo
02:44 - Pricing
03:56 - Create a Google Cloud project (optional)
05:05 - Enable GCP Text-To-Speech API
05:35 - Create a service account
08: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.org

00:00 - Overview & agenda
00:50 - API components
02:17 - Script development
03:07 - Step 1: Create an Assistant template
06:35 - Step 2: Create an assistant thread
07:42 - Step 3: Create a message thread
09:54 - Step 4: Send message to the assistant thread
11:53 - Step 5: Check message thread session status
12:10 - Step 6: Display Assistant's response
14:17 - Step 7: Ask follow up question

learn 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.org

00:00 - Intro to OpenAI Files API
00:35 - Files API pricing
02:45 - Files API examples (Python)
04:13 - Example: Upload a file
08:33 - Example: List files hosted on OpenAI's server
10:06 - Example: Upload multiple files
11:46 - Example: Retrieve a file
12:06 - Example: Delete a file
12: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.org

00:00 - GPT4 Vision Model Intro & Agenda
02:05 - API Key setup
04:07 - Example 1: Analyze image from the web
10:58 - Example 2: Analyze image from a local file
12:23 - Example 3: Extract image content
15: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.org

00:00 - Intro to AWS CloudFormation
02:03 - CloudFormation Example: JSON vs YAML
04: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.org

00:00 - Intro To Microsoft ToDo App API
01:17 - Create an Azure App
03:34 - Generate client secret
05:01 - Set Azure App permission
06: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.org

00:00 - Intro to (AWS Redshift) Amazon Redshift
00:57 - AWS Redshift Data Warehosue configuration
01:19 - Load data
04:53 - Query data
10: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.org

00:00 - Intro to AWS Athena
00:42 - Navigate to AWS Athena
00:54 - Create a workgroup
02:56 - Create S3 buckets
04:33 - Link S3 bucket to store query exports
05:25 - Create a database
05: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.org

00:00 - Intro To Microsoft Bing API
00:48 - Azure Bing Search API pricing
02:01 - Create a resource group
03:00 - Add Bing Search Resource
04:53 - Bing API Python package installation
05:05 - Generate Bing API access key
05: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.org

00:00 - Intro to AWS EC2
00:45 - Create Key Pair
02:02 - Create and Configure Security Group
04:42 - Create & setup an EC2 instance
07:45 - Connect to an EC2 instance
09: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

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.org

00:00 - Intro to Google Generative AI Python Client
01:17 - Create a Python Virtual Environment
01:53 - Install Google Generative AI Python SDK
02:07 - Create API key
04: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.org

0:00 - Introduction to the Tutorial
0:02 - Overview of AWS SQS and Its Benefits
0:08 - Explanation of Amazon AWS SQS
0:21 - Streamlining Workflow with SQS
0:36 - ETL Process Management with SQS
0:47 - Overview of SQS Pricing
1:38 - Personal Experience with SQS in ETL Pipelines
2:00 - Additional Costs: Data Transfer Usage
2:05 - Starting the SQS Tutorial
2:10 - Signing Up for AWS and Searching for SQS
2:29 - Understanding and Creating Queues in SQS
2:46 - Queue Types: Standard and FIFO Queue
3:17 - Choosing the Right Queue Type for Your Needs
4:07 - Queue Creation and Naming
4:26 - Queue Configuration Settings
5:14 - Encryption and Access Policy for Queues
5:56 - Creating and Configuring Additional Queues
6:31 - Understanding Redrive Allow Policy and Dead Letter Queue
7:12 - Queue Attributes and Message Filtering
7:56 - Sending Messages to the Queue
9:31 - Sending and Receiving Messages in SQS
10:36 - Retrieving and Analyzing Messages
11:43 - Message Details and Attributes
12:30 - Managing Message Visibility and Queue Refresh
13:05 - Processing Messages and Message Visibility
13:30 - Emptying and Managing the Queue
13: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.org

00:00 - Examples I will be covering
01:51 - Create a story from a photo
06:27 - Analyze a video with Gemini Vision Pro AI
09:19 - Create a tourism ad based on a video
11:02 - Figure out a price of a good using an image
13: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.org

00:00 - Into to Google Gemini
00:22 - Gemini API pricing
00:52 - Tutorial starts
01:16 - Create a Google Cloud Service Account
03:34 - Create environment variable for authentication
04: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.org

00:00 - Create users
02:26 - set up profile in user directory
06:03 - use a different profile
06:57 - provide the user credential access key manually

#aws #awstrainingvideos #awstraining