Quickie script to check an OpenAddresses source CSV file for a consistent number of rows

checkCsv.py

#!/usr/bin/env python3

"""Check a CSV source for consistent number of rows
Usage: checkCsv.py encoding filename"""

import sys

counts = {}
fp = open(sys.argv[2], encoding=sys.argv[1])
for l in fp:
    n = len(l.split(','))
    counts[n] = counts.get(n, 0) + 1
if len(counts.keys()) == 1:
    print("All rows in file have %s columns" % list(counts.keys())[0])
else:
    print("Rows have an inconsistent number of columns")
    for k in sorted(list(counts.keys())):
        print("  %3d %7d" % (k, counts[k]))