Parser for Healthcare_Associated_Infections.csv file

hai_parser.py

import csv

cities = dict()
counties = dict()
hosptials = dict()

with open('Healthcare_Associated_Infections.csv', 'r') as f:
    reader = csv.reader(f, delimiter=",")
    for i, row in enumerate(reader):
        
        if i == 0:
            continue

        city = row[3]
        county = row[6]
        hospital = row[1]
        
        if city in cities:
            cities[city] += 1
        else:
            cities[city] = 1

        if county in counties:
            counties[county] += 1
        else:
            counties[county] = 1
            
        if hospital in hosptials:
            hosptials[hospital] += 1
        else:
            hosptials[hospital] = 1

print("Total Cities: " + str(len(cities)))
print("Total counties: " + str(len(counties)))
print("Total Hospitals: " + str(len(hosptials)))