referral_codes.py

import csv

def generate_referral_code(first_name, last_name):
    first = first_name.lower().encode('ascii', errors='ignore').decode().replace(' ', '-')
    last = last_name.lower().encode('ascii', errors='ignore').decode().replace(' ', '-')

    return f"{first}-{last}".encode('ascii', errors='ignore').decode().replace('(', '').replace(')', '').replace('--', '-')

data = []
with open('file.csv', newline='', encoding='utf-8') as csvfile:
    reader = csv.DictReader(csvfile)

    # Add "Referral Code" column to each row

    for row in reader:
        row['Referral Code'] = generate_referral_code(row['First Name'], row['Last Name'])
        data.append(row)
        print(row['Referral Code'])

with open('new_file.csv', newline='', encoding='utf-8', mode='w') as csvfile:
    fieldnames = data[0].keys()
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    writer.writeheader()

    # Write each row to new file

    for row in data:
        writer.writerow(row)