Data merge error

[rr1997]

Hi,

I have tried to do a vLookUp throw data merge and the column "Instalações" that I need to get the values still empty.

Can someone help me?

The files that were mentioned on the python code are in this url: https://filebin.net/xyy3t7ffa2rs92sy

Thank you

import pandas as pd
import getpass
import sys
import datetime
from ftplib import FTP_TLS
import sys

user_id = getpass.getuser()

# Read Download and Dealers
data = pd.read_csv(r'C:/Users/'+ user_id +'/Desktop/Portable Script/Download_Report_Teleservices.csv',sep=";")
dealers = pd.read_csv(r'C:/Users/'+ user_id +'/Desktop/Portable Script/Teleservices_Support.csv',engine='python',sep=";")

data.head()

data = data.reindex(['Número do ponto de serviço autorizado','ID','VIN','Data de criação','Escalado em'], axis='columns')
data.columns = ['Local_ID','ID bilhete','Chassis','Entrada','Escalado']

# Add Telefone
data["Telefone"]=1

# Add current date column
data['Data Envio'] = pd.to_datetime('today').strftime("%d/%m/%Y")

data

dealers

# Merge, remove extra columns,
data_merged = pd.merge(dealers,how='left', left_on='Local_ID',right_on='Código')

data_merged
data_merged = data_merged.reindex(["Telefone","Local","ID bilhete","Chassis","Entrada","Escalado", "Data Envio"], axis='columns')
data_merged.columns = ['Telefone', 'Instalações', 'ID bilhete', 'Chassis', 'Entrada', 'Escalado', 'Data Envio']


# create today name
now = datetime.datetime.now()
Nday = str(now.day).zfill(2)
Nmonth = str(now.month).zfill(2)
Nyear = now.year
name = "Teleservices" + "_" + str(Nyear)+ "_" +str(Nmonth)+ "_" +str(Nday)


print(data_merged)
print(dealers)