SQL for Data Science #2: SQLite+pandas to analyze 10 million NYC citibike records
In this second part of the SQL for data science video I show you how to use Pandas to parse several large CSV files and load them in to a single SQLite database. This allows you to perform analysis in datasets that have several million rows.
Learn how to setup jupyter notebook:
https://www.youtube.com/watch?v=Q73ADVZCqSU
Part 1: Introduction to SQL
https://www.youtube.com/watch?v=7NSr6C8IhCo
Comments are closed.