pandas 生成html文档，支持可添加多个表 

如何通过pandas生成html格式？
如何通过pandas生成html文件文件中包含多个表单
Balance_64_data = pd.read_sql(Balance_64_sql,engine)

df = pd.DataFrame(np.random.randn(4,2))
df.columns = ['A', 'B']
df.index = ['a', 'b', 'c', 'd']

html_string = '''
<html>
  <head><title>HTML Pandas Dataframe with CSS</title></head>
  <link rel="stylesheet" type="text/css" href="df_style.css"/>
  <body>
    <div style="width:20px;margin-left: 20px;">{table} </div>
       <div style="height: 20px;width:"> </div>
        <div style="height: 20px;width:"> </div>
        <div style="height: 20px;width:"> </div>
        <div style="height: 20px;width:"> </div>
   <div style="height: 20px;width:20px;margin-left: 80px;"> {table1}</div>
    <div style="height: 20px;width:20px;float: right;"></div>
  </body>
</html>
'''
with open('myhtml.html', 'w') as f:
    f.write(html_string.format(table1=Balance_64_data.to_html(classes='mystyle'),table=df.to_html(classes='mystyle')))
posted @ 2020-11-17 21:05  耳机帽  阅读(788)  评论(0)    收藏  举报