Python dataframe columns from row&column header

Question

I have a data frame df1 like this:

       A    B     C   ...
mean   10   100   1
std    11   110   2
median 12   120   3

I want to make another df with separate col for each df1 col. header-row name pair:

A-mean   A-std   A-median   B-mean   B-std   B-median  C-mean   C-std   C-median   ...
10       11      12         100      110     120       1        2       3

Basically I have used the pandas.DataFrame.describe function and now I would like to transpose it this way.

Possible duplicate of How to reverse a 2-dimensional table (DataFrame) into a 1 dimensional list using Pandas? — Alperino
– Alperino, Commented Aug 1, 2022 at 15:19

Cameron Riddell · Accepted Answer · 2022-08-01 15:14:45Z

2

You can unstack your DataFrame into a Series, flatten the Index, turn it back into a DataFrame and transpose the result.

out = (
    df.unstack()
    .pipe(lambda s: 
        s.set_axis(s.index.map('-'.join))
    )
    .to_frame().T
)

print(out)
   A-mean  A-std  A-median  B-mean  B-std  B-median  C-mean  C-std  C-median
0      10     11        12     100    110       120       1      2         3

answered Aug 1, 2022 at 15:14

Cameron Riddell

13.8k14 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Python dataframe columns from row&column header

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related