Mar-24-2021, 03:25 PM
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
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)