How to Use SQL with Python
Descargar el Código: / pythonmaraton
Join Patreon: / pythonmaraton
^Downloadable code & more!
Learn Python:
Python Book (English): https://amzn.to/3HcwgLd
Libro de Python (Español): https://amzn.to/47woAhQ
Affordable Laptop: https://amzn.to/48L30Hb
Machine Learning Book: https://amzn.to/3RNmwfs
Libro de Aprendizaje automatico: https://amzn.to/3RVAFXU
Neural Networks for Babies: https://amzn.to/41SELoi
Video Equipment:
Background Color Light: https://amzn.to/3SgBDzG
Key Light: https://amzn.to/3NYwXLZ
Microphone: https://amzn.to/3H9UK89
Other:
Underrated Cheap Basketball: https://amzn.to/3RVzJTo
Amazing Basketball shorts: https://amzn.to/3vyRDUM You can use SQL in Python thanks to the library called SQLite. This Python package, mixed with Pandas, allows you to perform SQL queries on a database to be used in Python for analysis. This is a full tutorial designed to help those familiar with SQL use their SQL skills with Python.
0:00 Intro
0:35 Create .db from CSVs
2:04 Load .db file
2:45 SQL Table to Pandas
4:06 SQL Join & Max
4:30 SQL Order by (Sort)
5:17 SQL Group by
6:31 SQL Having (Condition)
7:02 SQL Aggregate Functions
7:49 SQL Group by 2 Columns
8:29 SQL Nested Queries
✅Subscribe: / @pythonmaraton
👍Facebook: / pythonmaraton
📧¿Aprendiendo Python? Únete al club para acceder anticipadamente al contenido:
https://adept-trader-9239.ck.page/85e...
🎵Theme Music: www.bensound.com
🔊Sound Effects: www.zapsplat.com
#PythonMarathon #CursoPython #AprenderPython