get_dataframe using iloc

Options
GeorgeAlex
GeorgeAlex Registered Posts: 3 ✭✭✭

instead of using

File_df = file.get_dataframe(columns =["TRANSPORTATION SERVICE PROVIDER","MAWB","HAWB","CARRIER/AIRLINE","SERVICE LEVEL","SHIPPER CITY (PICK UP LOCATION)",
# "SHIPPER STATE","SHIPPER COUNTRY","CONSIGNEE CITY","CONSIGNEE STATE","CONSIGNESS COUNTRY","PORT OF ARRIVAL",
# "ETD","ATD","ETA","ATA","BROKER TURNOVER","CUSTOMS CLEARED","DELIVERED"])

I want to use

File_df = file.get_dataframe( column location)

Reason - This recipe is reading files from different carriers which has different column names

Answers

Setup Info
    Tags
      Help me…