Pandas表格样式，你有table-style吗

本文链接：https://blog.csdn.net/a7303349/article/details/134215481

Pandas提供了style功能，可以直接实现excel里的高亮、色阶、数据条、单元格格式设置、字体设置等等功能，简单场景下不需要把数据导出再调整样式了，本文逐条盘点一下

数据生成

import pandas as pd
import numpy as np

np.random.seed(0)
df = pd.DataFrame(np.random.randn(10,4), columns=['A','B','C','D'])
df

1、高亮设置

def color_negative_red(val):
    
    color = 'red' if val < 0 else 'black'
    return 'color: %s' % color

df.style.applymap(color_negative_red,subset=['A','B','C','D'])

(
    df
    .style
    .applymap(color_negative_red,subset=['A','B','C','D'])
    .apply(highlight_max,subset=['A','B','C','D'])
)

2、百分比显示设置

df.style.format("{:.2%}",subset=['A','B'])

3、空值显示设置

df2=df.copy()
df2.loc[0,'B']=np.nan
df2.loc[3]=np.nan
df2.style.format(None, na_rep="-")

4、色阶设置

import seaborn as sns

cm = sns.light_palette("green", as_cmap=True)
s = df.style.background_gradient(cmap=cm)
s

5、数据条设置

(
    df
    .style
    .format("{:.2%}",subset=['A','B','C','D'])
    .bar(subset=['A', 'B'], color='#d65f5f')
)

6、字体颜色、大小、对齐、加粗设置

col_l=['A','B','C','D']
(
    df.style
    .format("{:.2%}",subset=['A','B','C','D'])
    .set_properties(**{'text-align': 'center'}, subset=col_l)  
    .set_properties(**{'font-size': '10pt'}, subset=col_l)  
    .set_properties(**{'font-weight': 'bold'}, subset=col_l)  
    .set_properties(**{'color': 'black'}, subset=col_l)
)