datamash -t, check < data.csv

Category: Data Science & Analysis

datamash -t, check < data.csv

Check a CSV for consistent field counts per row

The check operation verifies that every row has the same number of fields and that numeric columns contain only numbers. It prints the number of lines checked and reports any problems, making it a quick data-quality gate before analysis. Rows with missing trailing fields fail unless --no-strict is given. Run this on freshly exported spreadsheets before feeding them to statistics tools.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.