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.
En esta página del sitio puede ver el video en línea 07 - SQL in Python | Python Data Analysis Tutorial de Duración hora minuto segunda en buena calidad , que subió el usuario Eze Talamona 16 febrero 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 8,139 veces y le gustó 252 a los espectadores. Disfruta viendo!
