One of the things that greatly improved my csv workflow is duckdb. It’s a small binary that allows querying csv with sql.
sqlite> .import test.csv foo --csv sqlite -column :memory: '.import --csv file.csv tmp' 'select * from tmp;' | bat
For example, this is how I use YouTube. I never use the YouTube website, with its gigantic pages and its "Javascript player", not to mention all of the telemetry. All the search results and information about videos is stored in SQL or CSV, viewed with a text-only sqlite3 output .mode, and optionally converted to simple HTML.
For me, this is better than a "modern" web browser that's too large for me to compile.
Between those two, I can work with not only CSVs, but also JSON and Parquet files (which are blazing fast -- CSVs are good for human readability and editability, but they're horrendous for queries).
CLI CSV tools pop up every now and then, but there's too many of them and I feel that my use cases are sufficiently addressed with only 2 tools.
https://docs.pola.rs/py-polars/html/reference/api/polars.SQL...