07 - SQL in Python | Python Data Analysis Tutorial
📊 Google Data Analytics Certification 👉🏼 https://bit.ly/EzeT-GoogleCert-Esp
🧙♂️ Excel from Zero to Expert Course 👉🏼 https://analystground.gumroad.com/l/c...
🗞️ FREE Data Analyst Roadmap Guide 👉🏼 https://bit.ly/EzeTalamona-Newsletter
📜 Advanced Google Data Analytics Certification 👉🏼 https://bit.ly/EzeT-GoogleADA
🐍 Python for Data Analysis Book 👉🏼 https://amzn.to/42bz31o
📚 Data Science from Scratch Book 👉🏼 https://amzn.to/3FP8bwG
====================================
In this video, we cover how to perform SQL queries in Python on Data Frames created with pandas. We review the most commonly used SQL queries for data analysis and explore fundamental concepts.
00:00 Introduction
01:33 Libraries
02:06 Importing Data
02:46 Basic SELECT Queries
04:18 WHERE
07:04 GROUP BY
09:50 HAVING
10:30 LEFT JOIN
13:40 Merging in Pandas
15:22 Closing and Next Steps
🚀 Featured Content:
Importing and Exporting .csv Files
Generating SQL Queries in Python
Basic Queries: SELECT * FROM, WHERE
Data Grouping: GROUP BY
More Advanced Queries: LEFT JOIN, HAVING, LIMIT
GitHub Repo with Jupyter Notebooks from the Tutorial
💻 https://github.com/ezetalamona/youtub...
Link to the Kaggle Dataset Used in the Video
📈 https://www.kaggle.com/datasets/david...
Contact me =)
💼 LinkedIn - /ezetalamona
📸 Instagram - /ezetalamona
🐦 Twitter - /ezetalamona
As a member of the Coursera affiliate program, I earn a commission on qualifying purchases made through the links above. Thank you.
On this page of the site you can watch the video online 07 - SQL in Python | Python Data Analysis Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Eze Talamona 16 February 2024, share the link with friends and acquaintances, this video has already been watched 8,139 times on youtube and it was liked by 252 viewers. Enjoy your viewing!
