DuckDB in Python: Query CSV, Parquet, and Pandas with SQL
DuckDB in Python turns SQL into a zero-setup analytics engine: query CSV, Parquet, and Pandas DataFrames in-process, join across sources, and add UDFs.
DuckDB in Python turns SQL into a zero-setup analytics engine: query CSV, Parquet, and Pandas DataFrames in-process, join across sources, and add UDFs.
DuckDB vs Polars for data engineering in 2026: benchmarks, memory usage, SQL vs DataFrame ergonomics, and when to reach for each. Real numbers, honest verdict.
Polars vs Pandas in 2026: real benchmarks show 3-11x speedups on large data. Now Pandas 3.0 ships PyArrow strings, copy-on-write, and pd.col() expressions — …