pandas make column index a multiindex object

Question

using

pd_now.set_index("a")

We could make column "a" adding to the index of the "row index", making "row index" a multiindex object

However, I did not find any way to add a row "b" to the "column index", making "column index" a multiindex object. Did I miss anything? Thank you.

what i mean is, i want the df.columns (the df.columns is a index object) to be a multi-index. df.set_index(['a','b']) just makes the df.index a multiindex. — user40780
– user40780, Commented Nov 6, 2017 at 5:04

BENY · Accepted Answer · 2017-11-06 05:15:15Z

1

Using T and set_index

df.T.set_index(['a','b']).T

If you need add one

df.T.set_index('b',append=True).T

answered Nov 6, 2017 at 5:10

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Answer 1