lamiastella

csv

May 31st, 2016
288
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.86 KB | None | 0 0
  1. import csv
  2.  
  3. file1 = open("file1.csv", "r")
  4. file2 = open("file2.csv", "r")
  5.  
  6. csv_reader1 = csv.reader(file1)
  7. csv_reader2 = csv.reader(file2)
  8. #for row in csv_reader1:
  9. #    print(row)
  10.  
  11. dict1 = {}
  12. for row in csv_reader1:
  13.     dict1[row[0],row[1]] = row[2]
  14. dict2 = {}
  15. for row in csv_reader2:
  16.     dict2[row[0],row[1]] = row[2]
  17.  
  18. for key, value in dict1:
  19.     print key, value
  20.  
  21. file1.csv:
  22.  
  23. name, last_name, age, city, birthday, date
  24. mona, jalal, 28, Madison, 7/23/1987, 5/31/2016
  25. james, cardel, 29, DC, 7/23/1986, 5/1/2016
  26. kate, spade, 30, NYC, 7/32/1985, 5/24/2016
  27.  
  28. file2.csv:
  29. name, last_name, pet, pet_age
  30. mona, jalal, cat, 2
  31. kate, spade, dog, 3
  32. mina, nik anjam, bird, 1
  33.  
  34. /Library/Frameworks/Python.framework/Versions/2.7/bin/python2.7 /Users/mona/PycharmProjects/PythonCodes/CSV_calculation.py
  35. mona  jalal
  36. james  cardel
  37. kate  spade
  38. name  last_name
Advertisement
Add Comment
Please, Sign In to add comment