I generate a report from the pandas Data Frame. I need to divide headings into 3 sections. This is what my DF looks like:
| A | B | C | D | E | F |
|11 |10 |9,7|-2,3|802|64,4|
|24 |10 |9,1|0,2 |725|66,1|
|19 |20 |9,9|3,91|798|58,3|
Right now my headings have the same background colour but I need to divide them into 3 different sections. Headers A and B should have the same background colour lest say for example blue, headers C and D should have the colour green, and headers E and F should have the colour yellow. How to do that? Thanks for any help.
CodePudding user response:
variant by position
colors = ['blue', 'green', 'yellow']
N = len(colors) # 3
df.style.set_table_styles(
[{
'selector': f'th.level0.col{i}',
'props': [('background-color', colors[i//(df.shape[1]//N)])]
} for i in range(df.shape[1])
])