count the number of commas in a file and print if the number of commas is different than expected. useful for csv files where each row could have different number of commas breaking an import.

count_commas.py

# count the number of commas in a file and print if the number of commas is different than expected
import argparse
parser = argparse.ArgumentParser()
parser.add_argument("filename", help="filename")
parser.add_argument("commas", help="number of expected commas", type=int)
args = parser.parse_args()

file = args.filename
number_commas = int(args.commas)

with open(file, 'r') as csv_file:
    for line in csv_file:
        lc = line.count(',')
        if (lc != number_commas):
            print(lc,' - ',line)