Skip to content

Instantly share code, notes, and snippets.

@craigderington
Last active August 10, 2018 18:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save craigderington/850e742009bffb946d421e89e7e8bf1a to your computer and use it in GitHub Desktop.
Save craigderington/850e742009bffb946d421e89e7e8bf1a to your computer and use it in GitHub Desktop.
Create a Clean List from 2 Dictionaries by Filter on Key
# *-* coding: utf-8 *-*
import csv
d = {}
j = {}
followups = []
with open('data/campaign1.csv', 'r') as f1:
rows = csv.reader(f1)
for row in rows:
d.setdefault(row[2], []).append(row[0])
with open('data/campaign2.csv', 'r') as f2:
rows = csv.reader(f2)
for row in rows:
j.setdefault(row[2], []).append(row[0])
for name, idx in d.items():
if name not in j.keys():
print(name, idx[0])
followups.append(idx[0])
print(followups)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment