Keep just index and not name in pandas data frame

Question

I have a pandas data frame like this

variable    id Max
0   8004    5
1   8005    10
2   8006    9
3   8034    14
4   8046    3

if I check the df.columns I get

Index(['id', 'Max'], dtype='object', name='variable')

But I dont care the variable, I want to keep the information in the index but that appears as columns and delete the variable. I don't know if it is important, but I get the dataframe by pivoting another table.

Use `del df.index.name` – Vishnudev Krishnadas Apr 14 '20 at 04:00 — Vishnudev Krishnadas, Apr 14 '20 at 04:00
It doesn't work. Nothing change – LizUlloa Apr 14 '20 at 04:14 — LizUlloa, Apr 14 '20 at 04:14
What does `print(df.index.name)` give you? – Vishnudev Krishnadas Apr 14 '20 at 06:20 — Vishnudev Krishnadas, Apr 14 '20 at 06:20

score 0 · Answer 1 · answered Apr 14 '20 at 05:05

Use pandas.DataFrame.rename_axis with None as the argument:

import pandas as pd

df = pd.DataFrame(dict(
    variable = [0, 1, 2, 3, 4],
    id = [8004, 8005, 8006, 8034, 8046],
    Max = [5, 10, 9, 14, 3],
)).set_index('variable')

df = df.rename_axis(None)

Python Tutor link to example

Keep just index and not name in pandas data frame

1 Answers1