SQL for Data Science #2: SQLite+pandas to analyze 10 million NYC citibike records



SQL for Data Science #2: SQLite+pandas to analyze 10 million NYC citibike records

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.