Reindex columns

[eddywinch82]

Hi rr1997,

This is the Code I am using :-

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/Download_Report_Teleservices.csv',sep=";")
dealers = pd.read_csv(r'C:/Users/'+ user_id +'/Desktop/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 = data.merge(dealers,how='left', left_on='Local_ID',right_on='Código')
 
data_merged
data_merged = data_merged.loc[:,["Telefone","Local","ID bilhete","Chassis","Entrada","Escalado", "Data Envio"]]
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)
 
# Save file
data_merged.to_csv('C:/Users/'+ user_id +'/Desktop/' +  name + '.csv',sep=";",index=False,encoding='utf-8-sig')
#data_merged.to_csv('C:/Users/rfcr/Rigor/Caetano Retail - Organização/1 - Baviera/5 - Power BI/Teleservices/Daily Tickets/' +  name + '.csv',sep=";",index=False,encoding='utf-8-sig')
 
#Login to FTP (TLS secure)
ftp = FTP_TLS()
ftp.set_debuglevel(2)
ftp.connect('ftp.gruposalvadorcaetano.pt', port=21)
ftp.login(user='cretail.csi', passwd='cSvJCasuo2kzTH')
 
# Open File
file = open('C:/Users/'+ user_id +'/Desktop/' +  name + '.csv','rb')
 
# Change directory in FTP
ftp.cwd('/CCENTER/IN')
 
# Upload file to FTP with correct name
ftp.storbinary('STOR ' + name + '.csv', file)
 
# Close FTP and File
file.close()
ftp.close()
 
# Finsih Script
print("Finished")
sys.exit()

I have both .csv Files on my Desktop, and have the Output .csv File saved to the desktop too.

Try the above Code, you may not be getting the Output .csv File I get, due to an incorrect File Path(s) in the Code you are using, try putting both .csv Files on your Desktop like me.

Before trying the above suggestions, try changing the following two lines of Code.

From :-

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

To :-

# 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=";")

And changing this line of Code.

From :-

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

To :-

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

In the Code you provide, at the start of this Thread.

Best Regards

Eddie Winch