Convert row names into a column in Pandas

Question

I have the following Pandas data frame:

print(df)

     head1  head2  head3
bar     32      3    100
bix     22    NaN    NaN
foo     11      1    NaN
qux    NaN     10    NaN
xoo    NaN      2     20

What I want to do is to convert the row names bar, bix, ... into columns such that in the end I have something like this:

    newhead     head1  head2  head3
0   bar         32      3    100
1   bix         22    NaN    NaN
2   foo         11      1    NaN
3   qux         NaN    10    NaN
4   xoo         NaN     2     20

How can I achieve that?

score 56 · Accepted Answer · answered Aug 23 '14 at 02:37

56

df.index.name = 'newhead'
df.reset_index(inplace=True)

yields

  newhead  head1  head2  head3
0     bar     32      3    100
1     bix     22    NaN    NaN
2     foo     11      1    NaN
3     qux    NaN     10    NaN
4     xoo    NaN      2     20

answered Aug 23 '14 at 02:37

unutbu

842,883
184
1,785
1,677

score 11 · Answer 2 · answered Sep 16 '20 at 18:49

11

You can do it in one line.

df.rename_axis("newhead").reset_index()

answered Sep 16 '20 at 18:49

Chang Ye

1,105
1
12
25

1

Hi, @florian, Could you show me the version of your pandas package. – Chang Ye Jan 03 '21 at 07:15
@florian, the code is ok, maybe you should try: df = df.rename_axis("newhead").reset_index() – Rafael Braga Sep 26 '21 at 00:12

Convert row names into a column in Pandas

2 Answers2