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.
На этой странице сайта вы можете посмотреть видео онлайн 07 - SQL in Python | Python Data Analysis Tutorial длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Eze Talamona 16 Февраль 2024, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 8,139 раз и оно понравилось 252 зрителям. Приятного просмотра!
