Remove index name in pandas

PythonPandasIndexingRowname

Python Problem Overview

I have a dataframe like this one:

In [10]: df
Out[10]: 
         Column 1
foo              
Apples          1
Oranges         2
Puppies         3
Ducks           4

How to remove index name foo from that dataframe? The desired output is like this:

In [10]: df
Out[10]: 
         Column 1             
Apples          1
Oranges         2
Puppies         3
Ducks           4

Python Solutions

Solution 1 - Python

Alternatively you can just assign None to the index.name attribute:

>>> df.index.name = None
>>> print(df)
         Column 1    
Apples          1
Oranges         2
Puppies         3
Ducks           4

Solution 2 - Python

Use del df.index.name

In [16]: df
Out[16]:
         Column 1
foo
Apples          1
Oranges         2
Puppies         3
Ducks           4

In [17]: del df.index.name

In [18]: df
Out[18]:
         Column 1
Apples          1
Oranges         2
Puppies         3
Ducks           4

Solution 3 - Python

Took me way too long to find an answer that actually worked for me. See below.

df = df.rename_axis(None, axis=1)

I'm sure some of these other answers are working for other people, but they definitely didn't work for me :(

Solution 4 - Python

From version 0.18.0 you can use rename_axis:

print df
         Column 1
foo              
Apples          1
Oranges         2
Puppies         3
Ducks           4

print df.index.name
foo


print df.rename_axis(None)
         Column 1
Apples          1
Oranges         2
Puppies         3
Ducks           4

print df.rename_axis(None).index.name
None

# To modify the DataFrame itself:
df.rename_axis(None, inplace=True)
print df.index.name
None

Solution 5 - Python

for your case, just use the following code. tested on pandas 1.0.1.

df = df.rename_axis(index=None)

Solution 6 - Python

Simple change -- do it inplace:

df_degree.rename_axis(None, axis=1, inplace=True)
Categories
Recommended Python Solutions
Recommended Pandas Solutions
Recommended Indexing Solutions

Previous Solution:

LLDB (Swift): Casting Raw Address into Usable Type

IosSwiftLldb

Next Solution:

Visual Studio during Debugging: The function evaluation requires all threads to run

C#Visual Studio-Debugging

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
Questionmarkov zainView Question on Stackoverflow
Solution 1 - PythonEdChumView Answer on Stackoverflow
Solution 2 - PythonS AnandView Answer on Stackoverflow
Solution 3 - PythonMatthew WithrowView Answer on Stackoverflow
Solution 4 - PythonjezraelView Answer on Stackoverflow
Solution 5 - PythonKangView Answer on Stackoverflow
Solution 6 - PythonMattView Answer on Stackoverflow