De-dupe the signup email send list with the send list export from Sendy

dedupe_mandrill.py

#!/usr/bin/python

# De-dupe the signup email send list with the send list export from Sendy 

import os
import sys
import csv
import pprint

signup_emails = []
signup_send_list = {}
with open('~/Mandrill/edm-export-20200807.csv') as signup_fp:
    reader = csv.reader(signup_fp, delimiter=',', quotechar='"')
    for row in reader:
        signup_emails.append(row[0])
        signup_send_list[row[0]] = {
            'name' :  row[1],
            'subdomain' : row[2]
        }

mkt_emails = []
with open('~/Mandrill/edm-export-20200806.csv') as mkt_fp:
    reader = csv.reader(mkt_fp, delimiter=',', quotechar='"')
    for row in reader:
        mkt_emails.append(row[1])

deduped_send_list = [elem for elem in signup_emails if elem not in mkt_emails]

with open('~/Mandrill/edm-20200806.csv', 'wb') as deduped_fp:
    writer = csv.writer(deduped_fp, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
    rows = 0
    for deduped_email in deduped_send_list:
        rows += 1
        writer.writerow([deduped_email, signup_send_list[deduped_email]['name'], signup_send_list[deduped_email]['subdomain']])

print("Done. " + str(rows) + " rows written to file.")