November 1, 2024 1 minute read Since my previous post on DuckDB (DuckDB as the New jq), I’ve been continuing to use and enjoy DuckDB. Recently, I wanted to analyze and visualize some financial CSVs, including joining a few files together. I started out with Polars (which I understood to be a newer/better Pandas). However, as someone who doesn’t use it frequently, I found the syntax confusing and cumbersome. For example, here is how I parsed a Transactions.csv and summed entries by Category for r...