Pandas vs Polars vs DuckDB Benchmark

A comprehensive benchmark of Pandas, Polars, and DuckDB on a 16GB laptop processing 13.1 million rows (Susenas 2024). Demonstrated 98% memory reduction and 100x speedup using modern libraries. Includes detailed performance analysis across filtering, aggregation, and join operations.

Proof points

  • 13.1M Rows
  • 98% Less RAM
  • 100x Faster

Technologies

Python, Pandas, Polars, DuckDB, Jupyter Notebook

Links