4 ms·
Not trying to troll, but assuming proficiency in python, when would someone prefer this to say Pandas (or Polars)? I've written a lot of OLAP queries (wrote a
by __mharrison__ 4y ago
Not trying to troll, but assuming proficiency in python, when would someone prefer this to say Pandas (or Polars)?
I've written a lot of OLAP queries (wrote a materialization layer for MonetDb and Postgres years ago). I find Pandas so much easier to work with for semi complicated work.
- cdavid 4y agoThe obvious one is speed/data size: you can handle much larger data with duckdb compared to pandas. Depending on the data, maybe 10x larger, sometimes even more. From an ergonomics perspective, I find pandas much harder to use casually than SQL. When I was an IC and was using it a lot, I was proefficient in it. But now that I code maybe 5 hours / month at work, I can't really do anything non trivial besides basic stuff/pivots. OTOH, I never really forget SQL.