python 为html页面增加背景_python – Pandas dataframe.to_html() – 为标题添加背景颜色...

您可以尝试以两种方式执行此操作：

import pandas as pd

import numpy as np

# Set up a DataFrame

np.random.seed(24)

df = pd.DataFrame({'A': np.linspace(1, 10, 10)})

df = pd.concat([df, pd.DataFrame(np.random.randn(10, 4), columns=list('BCDE'))],

axis=1)

df.iloc[0, 2] = np.nan

df_html_output = df.style.set_table_styles(

[{'selector': 'thead th',

'props': [('background-color', 'red')]},

{'selector': 'thead th:first-child',

'props': [('display','none')]},

{'selector': 'tbody th:first-child',

'props': [('display','none')]}]

).render()

html.append(df_html_output)

body = '\r\n\n
'.join('%s'%item for item in html)

msg.attach(MIMEText(body, 'html'))

df_html_output = df.to_html(na_rep = "", index = False).replace('

','')

html.append(df_html_output)

body = '\r\n\n
'.join('%s'%item for item in html)

msg.attach(MIMEText(body, 'html'))

第二个提供了在导出期间删除索引列的选项(to_html),而无需进行太多的HTML调整;所以它可能更适合您的需求.

我希望这证明是有用的.