How to remove the index name in pandas dataframe?

Question

In my dataframe, I get a '2' written over my index column's name. when I check for the columns name it doesn't show up there but as df.columns give this as output. I don't know how to remove that '2' from my dataset.

I have tried removing index name but it hasn't solved my issue.

 df.columns ==> Output
     Index(['name', 'census 1981', 'census 1998', 'estimate 2000',
       'calculation 2010', 'annual growth', 'latitude', 'longitude',
       'parent division', 'name variants'],
      dtype='object', name=2)

I expect only the index with its name...not including that freaking '2' over it

A similar post.

Azhar Khan
– Azhar Khan

2022-11-09 09:30:27 +00:00
Commented Nov 9, 2022 at 9:30 — Azhar Khan
– Azhar Khan, Commented Nov 9, 2022 at 9:30

ansev · Accepted Answer · 2019-08-31 12:57:11Z

12

you need change the name of columns, not index!

df.columns.name=''

Example to understand it:

df=pd.DataFrame()
df['a']=[1,2,3]
df.columns.name='name column'
df.index.name='name index'
df

Output:

name column  a
name index  
0            1
1            2
2            3

Now doing:

df.columns.name=''

Output:

           a
name index  
0          1
1          2
2          3

edited Aug 31, 2019 at 12:57

answered Aug 31, 2019 at 12:49

ansev

31k5 gold badges21 silver badges33 bronze badges

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

3 Comments

Jawad Over a year ago

I renamed the columns, it solved the issue! Thanks bud!

Steve Over a year ago

Finally solved my problem after search for almost 1 hour. Thank you!

ansev Over a year ago

You are welcome @Steve We could use : df = df.rename_axis(columns='') pandas.pydata.org/pandas-docs/stable/reference/api/…

Abdul Rafay Jungsher · Accepted Answer · 2019-08-31 12:54:50Z

4

To modify the DataFrame itself:

df.rename_axis(None, inplace=True)

answered Aug 31, 2019 at 12:54

Abdul Rafay Jungsher

5164 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to remove the index name in pandas dataframe?

2 Answers 2

3 Comments

To modify the DataFrame itself:

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

To modify the DataFrame itself:

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related