This is a continuation of the third part of my SQL for data science video series (link below).
In this third part of the SQL for data science video series, I show you how to use Pandas to execute SQL queries using SQLite as a backend database. I show case the power of SQL by writing simple, declarative queries that return resuts in seconds.
Learn how to setup jupyter notebook:
• Data Analysis of Uber trip data using Pyth...
Part 1: Introduction to SQL
• SQL for Data Science #1: Introduction to SQL
Part 2: Pandas to ingest large datasets into SQLite
https://www.youtube.com/edit?o=U&vide...
Part 3a: Simple Queries
• SQL for Data Science #3a: SQLite+pandas to...