DuckDB - High-Performance SQL Queries on Pandas Dataframe - Python
Explore the powerful capabilities of DuckDB for high-performance SQL queries on pandas dataframes in Python through this comprehensive 44-minute video tutorial. Dive into the world of "SQLite for Analytics" as the instructor explains why DuckDB is designed to be user-friendly for data scientists. Learn about database interfaces with applications, take a quick tour of the DuckDB shell, and discover how to utilize the DuckDB Python package with pandas. Master the art of executing multiline SQL queries on pandas dataframes and explore various tools for working with DuckDB. Gain valuable insights into related topics such as converting CSV to SQLite, hands-on SQL introduction, running SQLite in VSCode, and building dashboards with PyScript and Altair.