You can also use xsv for this kind of analysis of CSV files. Which is a unix-style tool designed for CSVs and with a proper CSV parser.

It's written in Rust so it's one binary - no runtime dependencies, and will happily chunk through multi-gigabyte files.

https://github.com/BurntSushi/xsv