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.
Nesta página do site você pode assistir ao vídeo on-line 07 - SQL in Python | Python Data Analysis Tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Eze Talamona 16 Fevereiro 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 8,139 vezes e gostou 252 espectadores. Boa visualização!
