How to highlight columns inside multiindex in a pandas dataframe?

Question

I wish to highlight 'C2' and the values corresponding to 'C2' in columns 'D' and 'E'. I have difficulty as this is a multiindex, and subset selection of columns is not obvious.

df_all = pd.DataFrame()
for i in range(3):
    df_temp = pd.DataFrame(
        data={'D': [0, 23*i, 19*i],
              'E': [18*i, 90*i, -29*i]
        },
        index=pd.MultiIndex.from_tuples([(0, 1, 'C1'), (3, 4, 'C2'), (6, 8, 'C3')], names=["A", "B", "C"])
    )
    df_all = df_all.append(df_temp)

df_all

The frame.append method is deprecated and will be removed from pandas in a future version. One might want to change df_all = df_all.append(df_temp) to df_all = pd.concat([df_all, df_temp], axis=0). — Gonçalo Peres
– Gonçalo Peres, Commented Oct 5, 2022 at 11:24

Ynjxsjmh · Accepted Answer · 2022-10-05 11:22:52Z

1

Let's try

idx = pd.IndexSlice
slice_ = idx[idx[:, :, 'C2'], :]

def highlight_c2(s):
    return ['background-color: #ffffb3;' if v == 'C2' else '' for v in s]

s = (df_all.style
     .set_properties(**{'background-color': '#ffffb3'}, subset=slice_)
     .apply_index(highlight_c2, axis=0, level=[2])
     )
s.to_html('73959317.html')

answered Oct 5, 2022 at 11:22

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

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

2 Comments

Bravo Over a year ago

Thanks, how does this change, if I want to highlight only 'D' and not 'E'?

Ynjxsjmh Over a year ago

@Bravo Use slice_ = idx[idx[:, :, 'C2'], ['D']].

Collectives™ on Stack Overflow

How to highlight columns inside multiindex in a pandas dataframe?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related