Siuba and duckdb: Analyzing Everything Everywhere All at Once
summary
siuba provides a dplyr‑style Python API that generates SQL for duckdb via SQLAlchemy so the same verbs can target pandas, polars, parquet files and pins on Posit Connect; the experiment called duckOps imports duckdb functions to let users call native duckdb operations as Python functions (discoverable, partialable, lazy expressions) while siuba generates SQL via SQLAlchemy and translates some pandas methods back into duckdb SQL. The system works as a promising unified path though method‑translation quirks remain to be smoothed.
AI-written summary · about
chapters (5)
related talks
39mPython and SQL: Better Together, Powered by DuckDB
30mDuckDB: Bringing analytical SQL directly to your Python shell
34mData Wrangling with DuckDB
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
29m"Serpents and Ducks: wrangling data with Python and DuckDB"
27mIn Process Analytical Data Management with DuckDB
28mAnalyze data easily with duckdb - and the implications on data architectures
01h 02mAnalytics for not-so-big data with DuckDB