finding dupes (with a twist)

[buran]

Ah, my mistake

import pandas as pd 
 
df_dupes = pd.read_csv('dupes.csv') # dupes
dfe = pd.read_csv('exceptions.csv') # the exceptions
# make sure email is lower case
df_dupes['Email'] = df_dupes['Email'].apply(lambda x: x.lower())
dfe['Email'] = dfe['Email'].apply(lambda x: x.lower())

# get just the records from dupes where email not in exceptions
df_clean = df_dupes[~df_dupes['Email'].isin(dfe['Email'])]
print(df_clean)