Guest User

Untitled

a guest
Oct 23rd, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. import csv
  2.  
  3. with open('before.csv', 'r') as before:
  4. before_indices = dict((i[2], i[3]) for i in csv.reader(before))
  5.  
  6.  
  7. with open('after.csv', 'r') as reportAfter:
  8. with open('results.csv', 'w') as results:
  9. reader = csv.reader(reportAfter)
  10. writer = csv.writer(results, quoting=csv.QUOTE_NONNUMERIC)
  11.  
  12. for row in reader:
  13. value = before_indices.get(row[2])
  14.  
  15. if float(row[3]) > 1.1*float(value) or float(row[3]) < 0.9*float(value):
  16. writer.writerow([int(row[0]),int(row[1]),row[2],int(value),int(row[3])])
Add Comment
Please, Sign In to add comment