Csv

DuckDB client CLI is much faster, nicer and robust than any other CSV-querying tools I used before (csvq, q etc):

duckdb -c "SELECT COUNT(*),type FROM read_csv_auto('yourfile.csv') group by type order by 1;"