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.
Sur cette page du site, vous pouvez voir la vidéo en ligne 07 - SQL in Python | Python Data Analysis Tutorial durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Eze Talamona 16 février 2024, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 8,139 fois et il a aimé 252 téléspectateurs. Bon visionnage!
