CVS dedupe

dedupe.py

import csv

uniques = {}

with open('original.csv') as csv_file:
    reader = csv.DictReader(csv_file)
    for row in reader:
        if row['Password'] == '':
            if row['Group'] == 'Root':
                row['Group'] = 'Root/Non_Login'
            key = ("Other", row['Title'])
        else:
            key = ("Login", row['Title'], row['Username'])

        if key in uniques:
            print("Dup!", key)
        else:
            uniques[key] = row
        
with open('no_dupes.csv', "w") as csv_export:
    writer = csv.DictWriter(csv_export, fieldnames=reader.fieldnames)

    writer.writeheader()
    for row in uniques.values():
        writer.writerow(row)