import os
import csv
with open('f1.csv') as f1, open('f2.csv') as f2, open('out', 'w') as out:
reader = csv.reader(f1, delimiter='\t')
writer = csv.writer(out, delimiter='\t')
lines = set(line.strip() for line in f2)
for row in reader:
if row[1] in lines:
row[1] = '123'
writer.writerow(row)
os.rename('out', 'f1.csv')
aW1wb3J0IG9zCmltcG9ydCBjc3YKCndpdGggb3BlbignZjEuY3N2JykgYXMgZjEsIG9wZW4oJ2YyLmNzdicpIGFzIGYyLCBvcGVuKCdvdXQnLCAndycpIGFzIG91dDoKICAgIHJlYWRlciA9IGNzdi5yZWFkZXIoZjEsIGRlbGltaXRlcj0nXHQnKQogICAgd3JpdGVyID0gY3N2LndyaXRlcihvdXQsIGRlbGltaXRlcj0nXHQnKQogICAgbGluZXMgPSBzZXQobGluZS5zdHJpcCgpIGZvciBsaW5lIGluIGYyKQogICAgZm9yIHJvdyBpbiByZWFkZXI6CiAgICAgICAgaWYgcm93WzFdIGluIGxpbmVzOgogICAgICAgICAgICByb3dbMV0gPSAnMTIzJwogICAgICAgIHdyaXRlci53cml0ZXJvdyhyb3cpCm9zLnJlbmFtZSgnb3V0JywgJ2YxLmNzdicpCg==