Solution

import pandas as pd

CX_order_report = pd.read_excel("COURIER DATA/Company X - Order Report.xlsx")
CX_order_report.head()

CC_invoice = pd.read_excel(r"COURIER DATA/Courier Company - Invoice.xlsx")
CC_invoice.head()

CX_SKU_Master = pd.read_excel(r"COURIER DATA/Company X - SKU Master.xlsx")
CX_SKU_Master.head()

CC_Rates = pd.read_excel(r"COURIER DATA/Courier Company - Rates.xlsx")
CC_Rates.head()

CX_Pincode_Zones = pd.read_excel(r"COURIER DATA\Company X - Pincode Zones.xlsx")
CX_Pincode_Zones.head()
CX_Pincode_Zones

# renaming all the columns as x as client x and cc as courier company

CX_Pincode_Zones.rename(columns = {'Zone':'zone_X'}, inplace = True)
CX_Pincode_Zones