Python: Copying certain columns to an empty dataframe using For loop

Question

wo = "C:/temp/temp/WO.xlsx"
dfwo = pd.read_excel(wo)

columnnames = ["TicketID","CreateDate","Status","Summary","CreatedBy","Company"]
main = pd.DataFrame(columns = columnnames)

for i in range(0,15):
    print(i)
    main["TicketID"][i] = dfwo["WO ID"][i]
    main["CreateDate"][i] = dfwo["WO Create TimeStamp"][i]
    main["Status"][i] = dfwo["Status"][i]
    main["Summary"][i] = dfwo["WO Summary"][i]
    main["CreatedBy"][i] = dfwo["Submitter Full Name"][i]
    main["Company"][i] = dfwo["Company"][i]

I am trying to copy selected columns from 1 df to another. dfwo is a df derived from Excel Main is an empty dataframe and has selected columns from dfwo

When I run this code, it gives me the error, "IndexError: index 0 is out of bounds for axis 0 with size 0"

Any suggestions pls?

bigbounty · Accepted Answer · 2020-07-16 03:47:09Z

2

wo = "C:/temp/temp/WO.xlsx"
dfwo = pd.read_excel(wo)

columnnames =["TicketID","CreateDate","Status","Summary","CreatedBy","Company"]
main = dfwo[columnnames]
new_col_names =  {
    "TicketID":"WO ID",
    "CreateDate":"WO Create TimeStamp",
    "Status":"Status",
    "Summary":"WO Summary",
    "CreatedBy":"Submitter Full Name",
    "Company":"Company"
}
main.rename(columns = new_col_names,inplace = True)

edited Jul 16, 2020 at 3:47

answered Jul 16, 2020 at 3:39

bigbounty

17.5k7 gold badges45 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anoop Mahajan Over a year ago

Column names in dfwo are not same. I cant keep the names of columns in Main same as dfwo as I plan to combine more df data into Main later.

Anoop Mahajan Over a year ago

Thanks @bigbounty. However, do you know what was wrong with the For loop approach?

Collectives™ on Stack Overflow

Python: Copying certain columns to an empty dataframe using For loop

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related