Fugue and DuckDB: Fast SQL Code in Python

Optimize Your SQL Code with Python and DuckDB

Motivation

As a data scientist, you might be familiar with both Pandas and SQL. However, there might be some queries, transformations that you feel comfortable doing in SQL instead of Python.

Wouldn’t it be nice if you can query a pandas DataFrame using SQL…

Image by Author