import pandas as pddf = pd.read_csv('путь до файла)df = read_excel('путь до файла)for y in text_input:
text_input_index = y[0]
text_input_address = y[-1]
csv_input.loc[csv_input['index'] == int(text_input_index),
'new_address'] = text_input_address