How should I merge an index with header name in pandas?

Question

I'm trying to merge the index with header name. My data frame is like

t  = pd.DataFrame({'A': ['a', 'b']})
t

    A
0   a
1   b

But the desired output is

    A_0     A_1
0   a       b

anky · Accepted Answer · 2019-09-01 12:41:35Z

2

Try with unstack() , then transpose , then join the multiindex columns:

final=t.unstack().to_frame().T
final.columns=['_'.join(map(str,i)) for i in final.columns]
print(final)

  A_0 A_1
0   a   b

answered Sep 1, 2019 at 12:41

anky

75.3k11 gold badges46 silver badges76 bronze badges

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

2 Comments

I was about to post the same verbatim answer with even variable names :)

@iDrwish aha..co-incidence ;)