Error at removing column from pandas dataframe

Question

I've received an error after trying to remove a column from my dataframe. KeyError: "['column name'] not found in axis" Advice is to put axis=1, but I did that and I still receive the same error. I don't know, what the problem is.

  
for i in range(1,len(file_list)):
    data = pd.read_table(file_list[i], encoding='unicode_escape')
    df = pd.DataFrame(data)
    main_dataframe = pd.concat([main_dataframe, df], axis = 1)

main_dataframe = main_dataframe.drop('column name',axis=1)

There are a couple of things wrong here that are not directly related to your question but might be helpful: (1) Python starts indexing at 0 not 1, so your code will not be reading the first file. (2) You can just iterate through the file list for file_name in file_list: (3) calling pd.concat in a loop is inefficient, try appending all dataframes to a list first after reading and then calling pd.concat once at the end. — Hans
– Hans, Commented May 4, 2022 at 9:44

robinood · Accepted Answer · 2022-05-04 09:31:41Z

1

"column name" is a placeholder for your actual column name. For example, if you want to delete a column named "Surname", use:

df = df.drop("Surname",axis=1)

The error you have here is clearly stating that there is no column named "column name" in your dataframe.

answered May 4, 2022 at 9:31

robinood

1,24810 silver badges18 bronze badges

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

1 Comment

JJi Over a year ago

I was aware of that ^^ But thank you. I figuered it out, something else was wrong...

Collectives™ on Stack Overflow

Error at removing column from pandas dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related