Advertisement
Guest User

Untitled

a guest
Oct 20th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. import csv
  2. reader = csv.reader(open('dictionary.csv', 'r'), skipinitialspace=True,delimiter
  3. =',', quoting=csv.QUOTE_NONE)
  4. writer = open("out.csv", "w")
  5. d = {}
  6. for row in reader:
  7. k, v = row
  8. d[k] = v
  9.  
  10. print(d["four four"])
  11. reader2 = csv.reader(open('input.csv', 'r'),skipinitialspace=True,delimiter=',',
  12. quoting=csv.QUOTE_NONE)
  13. for row2 in reader2:
  14. c1, c2, c3 = row2
  15. outval = "ERR"
  16. if c2 in d:
  17. outval = d[c2]
  18.  
  19. writer.write("".join([c1,",",c2,",",c3,", ",outval,"\n"]))
  20.  
  21. print("Done")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement