pandas DataFrame remove Index from columns

Question

I have a dataFrame, such that when I execute:

df.columns

I get

Index(['a', 'b', 'c'])

I need to remove Index to have columns as list of strings, and was trying:

df.columns = df.columns.tolist()

but this doesn't remove Index.

I think you're confusing index, that is a pandas index object, your columns are indeed strings and a list if you call more than one. What are you trying to do? — Umar.H
– Umar.H, Commented Mar 18, 2021 at 14:54
df.columns is always of type pd.Index no matter if you assign them as list. you can use them as lists where you want to. — anky
– anky, Commented Mar 18, 2021 at 15:01

Nike · Accepted Answer · 2021-03-18 15:22:33Z

1

tolist() should be able to convert the Index object to a list:

df1 = df.columns.tolist()
print(df1)

or use values to convert it to an array:

df1 = df.columns.values

The columns attribute of a pandas dataframe returns an Index object, you cannot assign the list back to the df.columns (as in your original code df.columns = df.columns.tolist()), but you can assign the list to another variable.

edited Mar 18, 2021 at 15:22

answered Mar 18, 2021 at 15:11

Nike

1,3092 gold badges21 silver badges45 bronze badges

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

1 Comment

Paul H Over a year ago

this is definitely not what the OP wants

Collectives™ on Stack Overflow

pandas DataFrame remove Index from columns

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related