Resolve levels in pivot table in pandas

Question

Assume, I have following pivoted DataFrame:

|   ID |   0 |   1 |   2 |
|    0                   |
|-----:|----:|----:|----:|
| 1115 | nan | "YE"| nan |
| 1590 | nan | "He"| "NO"|

How can I remove this 0 column, so that I get this representation:

|   ID |   0 |   1 |   2 |
|-----:|----:|----:|----:|
| 1115 | nan | "YE"| nan |
| 1590 | nan | "He"| "NO"|

Note: It is not a row.

EDIT:

Index:

df.index
Int64Index([   0,  2],
           dtype='int64', name=0, length=3)

Columns:

df.columns
Int64Index([   0,   1,   2],
           dtype='int64', name='ID', length=3)

Grzegorz Skibinski · Answer 1 · 2020-03-29T07:57:40.567

0

Try:

del df.index.name

You just need to get rid of index name parameter.

edited Mar 29 '20 at 07:57

answered Mar 28 '20 at 12:11

```TypeError: 'int' object is not subscriptable``` Int64Index([ 0,1,2], dtype='int64', name='ID', length=3) – EchoCache Mar 28 '20 at 21:48
Can you share ```print(df.columns)``` and ```print(df.index)``` – Grzegorz Skibinski Mar 28 '20 at 22:34
Question updated. – EchoCache Mar 28 '20 at 23:48
Thanks, please check my answer now - this should do the trick – Grzegorz Skibinski Mar 29 '20 at 07:58
unfortunately, it says: ```AttributeError: can't delete attribute``` – EchoCache Mar 29 '20 at 15:21
Hm, maybe you need to upgrade your ```pandas``` and/or python. Try instead: ```df.index.name=''``` (assign empty string to it) – Grzegorz Skibinski Mar 29 '20 at 15:45

1 Answers1