Convert a dataframe with multiple rows into one row using pandas?

Question

Having the following dataframe,

      0      1      2
A    0.2    0.4    0.6
B    0.1    0.1    0.3

How to achieve this transformation, while merging the row index with column name?

     A_0    A_1    A_2    B_0    B_1    B_2
0    0.2    0.4    0.6    0.1    0.1    0.3

root · Accepted Answer · 2016-05-05 17:30:40Z

12

Use stack followed by a transpose to get the DataFrame in the right shape, then format the column names as appropriate.

df = df.stack().to_frame().T
df.columns = ['{}_{}'.format(*c) for c in df.columns]

answered May 5, 2016 at 17:30

root

34.1k6 gold badges77 silver badges89 bronze badges

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

1 Answer 1