用内联样式而不是CSS将pandas DataFrame转换为html [英] pandas DataFrame to html with inline styles instead of CSS
本文介绍了用内联样式而不是CSS将pandas DataFrame转换为html的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在尝试将HTML格式的pandas DataFrame作为电子邮件的一部分发送.我正在尝试使用
I am trying to send a pandas DataFrame as HTML as part of an email. I was trying to use something like
import pandas as pd
df = pd.DataFrame({1: [1, 2, 3], 2: [4, 5, 6]})
def style_map(x):
return 'color: red' if x == 1 else 'color: blue'
styled_df = df.style.applymap(style_map).render()
，然后将styled_df添加到其余的HTML.但是，此方法使用CSS设置表格样式，并且输出如下所示:
and then add styled_df to the remaining HTML. However, this method uses CSS to style the table, and the output looks like this:
<style type="text/css" >
#T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row0_col0 {
color: red;
} #T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row0_col1 {
color: blue;
} #T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row1_col0 {
color: blue;
} #T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row1_col1 {
color: blue;
} #T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row2_col0 {
color: blue;
} #T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row2_col1 {
color: blue;
}</style><table id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4" ><thead> <tr> <th class="blank level0" ></th> <th class="col_heading level0 col0" >1</th> <th class="col_heading level0 col1" >2</th> </tr></thead><tbody>
<tr>
<th id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4level0_row0" class="row_heading level0 row0" >0</th>
<td id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row0_col0" class="data row0 col0" >1</td>
<td id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row0_col1" class="data row0 col1" >4</td>
</tr>
<tr>
<th id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4level0_row1" class="row_heading level0 row1" >1</th>
<td id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row1_col0" class="data row1 col0" >2</td>
<td id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row1_col1" class="data row1 col1" >5</td>
</tr>
<tr>
<th id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4level0_row2" class="row_heading level0 row2" >2</th>
<td id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row2_col0" class="data row2 col0" >3</td>
<td id="T_3627a1a0_4fb7_11e9_9bf9_33657f3526e4row2_col1" class="data row2 col1" >6</td>
</tr>
</tbody></table>
在这种情况下，大多数电子邮件客户端将忽略样式.
in which case the styles will be ignored by most email clients.
我的问题是:是否有一种(简单的方法)将样式信息移至单个单元格的style=属性中?
My question is: is there an (easy?) way to move the style information into the style= attributes of the individual cells?
推荐答案
一种方法是将Pandas自身的样式与Python模块结合使用，以将CSS转换为内联样式(例如，
One approach would be to combine Pandas' own styling with a Python module for turning CSS into inline styles (cf. e.g. this SO post).
例如，使用 premailer :
In [1]: from premailer import transform
In [2]: import pandas as pd
...:
...: df = pd.DataFrame({1: [1, 2, 3], 2: [4, 5, 6]})
...:
...: def style_map(x):
...: return 'color: red' if x == 1 else 'color: blue'
...:
...: styled_df = df.style.applymap(style_map).render()
In [4]: print(transform(styled_df))
<html><head></head><body><table id="T_47851dee_4fbf_11e9_9c6a_f5d370129713"><thead> <tr> <th class="blank level0"></th> <th class="col_heading level0 col0">1</th> <th class="col_heading level0 col1">2</th> </tr></thead><tbody>
<tr>
<th id="T_47851dee_4fbf_11e9_9c6a_f5d370129713level0_row0" class="row_heading level0 row0">0</th>
<td id="T_47851dee_4fbf_11e9_9c6a_f5d370129713row0_col0" class="data row0 col0" style="color:red">1</td>
<td id="T_47851dee_4fbf_11e9_9c6a_f5d370129713row0_col1" class="data row0 col1" style="color:blue">4</td>
</tr>
<tr>
<th id="T_47851dee_4fbf_11e9_9c6a_f5d370129713level0_row1" class="row_heading level0 row1">1</th>
<td id="T_47851dee_4fbf_11e9_9c6a_f5d370129713row1_col0" class="data row1 col0" style="color:blue">2</td>
<td id="T_47851dee_4fbf_11e9_9c6a_f5d370129713row1_col1" class="data row1 col1" style="color:blue">5</td>
</tr>
<tr>
<th id="T_47851dee_4fbf_11e9_9c6a_f5d370129713level0_row2" class="row_heading level0 row2">2</th>
<td id="T_47851dee_4fbf_11e9_9c6a_f5d370129713row2_col0" class="data row2 col0" style="color:blue">3</td>
<td id="T_47851dee_4fbf_11e9_9c6a_f5d370129713row2_col1" class="data row2 col1" style="color:blue">6</td>
</tr>
</tbody></table></body></html>
这篇关于用内联样式而不是CSS将pandas DataFrame转换为html的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
