Grouping multiple columns under same header in dataframe

Question

These are my 3 current dataframes with same columns -

TP FP     TP FP     TP FP
 1  3      8 11      4  7
22 14     10 13      0 19

Here's how I want it in a single dataframe-

OCT-19    NOV-19    DEC-19
TP  FP    TP  FP    TP FP
 1   3     8  11     4  7
22  14    10  13     0 19

Richard X · Accepted Answer · 2020-01-10 06:12:08Z

1

headers = pd.MultiIndex.from_product([["OCT-19"], ["TP", "FP"]])
df1 = pd.DataFrame([[1, 3], [22, 14]], columns=headers)

Just use MultiIndex.from_product() to specify the headers you want for your columns. Then you can pass these headers into the columns of your dataframe.

answered Jan 10, 2020 at 6:12

Richard X

1,1348 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Grouping multiple columns under same header in dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related