import pandas as pd
df = 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