DuckDB - Bringing Analytical SQL Directly to Your Python Shell

Explore the innovative DuckDB system in this 42-minute conference talk from EuroPython 2023. Discover how DuckDB executes analytical SQL queries without a server and seamlessly integrates with the PyData ecosystem. Learn about its unique ability to query and output data from and to other Python libraries without data copying, making it an essential tool for data scientists. Witness a live demonstration showcasing DuckDB's performance and integration with Pandas in a typical data science scenario, comparing their performance and usability while highlighting their cooperation. Gain insights into DuckDB's main characteristics and its potential to enhance your data analysis workflow. This talk is particularly valuable for those familiar with Python, the Pandas API, and SQL.