Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- with open('before.csv', 'r') as before:
- before_indices = dict((i[2], i[3]) for i in csv.reader(before))
- with open('after.csv', 'r') as reportAfter:
- with open('results.csv', 'w') as results:
- reader = csv.reader(reportAfter)
- writer = csv.writer(results, quoting=csv.QUOTE_NONNUMERIC)
- for row in reader:
- value = before_indices.get(row[2])
- if float(row[3]) > 1.1*float(value) or float(row[3]) < 0.9*float(value):
- writer.writerow([int(row[0]),int(row[1]),row[2],int(value),int(row[3])])
Add Comment
Please, Sign In to add comment