python项目应用实例(四)用pandas将结果写入html表格之中

- 日理万妓 2022-01-31 09:11 289阅读 0赞

参考：[https://blog.csdn.net/tz\_zs/article/details/81137998][https_blog.csdn.net_tz_zs_article_details_81137998]

官方API文档：[http://pandas.pydata.org/pandas-docs/version/0.19.0/generated/pandas.DataFrame.to\_html.html][http_pandas.pydata.org_pandas-docs_version_0.19.0_generated_pandas.DataFrame.to_html.html]

**目录**

一、创建表格

1.1 例程

二、写出结果

2.1 index

2.2 df

2.3 写入html文件

2.4 结果

--------------------

# 一、创建表格 #

[https://blog.csdn.net/tz\_zs/article/details/81137998][https_blog.csdn.net_tz_zs_article_details_81137998]

## 1.1 例程 ##

# -*- coding: utf-8 -*-
    """
    @author: tz_zs
    """
    import matplotlib.pyplot as plt
    import numpy as np
    import pandas as pd
     
    index = ["2018-07-01", "2018-07-02", "2018-07-03", "2018-07-04"]
    df = pd.DataFrame(index=index)
    df["一"] = [11, 12, 13, 14]
    df["二"] = [21, 22, 23, 24]
    print(df)
    """
                 一   二
    2018-07-01  11  21
    2018-07-02  12  22
    2018-07-03  13  23
    2018-07-04  14  24
    """
     
    axes_subplot = df.plot()
    # print(type(axes_subplot)) #<class 'matplotlib.axes._subplots.AxesSubplot'>
    plt.xlabel("time")
    plt.ylabel("num")
    plt.legend(loc="best")
    plt.grid(True)
    plt.savefig("test.png")
     
    HEADER = '''
        <html>
            <head>
                <meta charset="UTF-8">
            </head>
            <body>
        '''
    FOOTER = '''
            <img src="%s" alt="" width="1200" height="600">
            </body>
        </html>
        ''' % ("test.png")
    with open("test.html", 'w') as f:
        f.write(HEADER)
        f.write(df.to_html(classes='df'))
        f.write(FOOTER)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zNjQ3NDgwOQ_size_16_color_FFFFFF_t_70][]

## 二、写出结果 ##

## 2.1 index ##

为左边一竖排，与df的key不一样。df中的元素与index一一对应

def write_clases_result_into_html(self):
            print('writing result into html')
            index=[]
            for class_idx in range(self.class_num):
                index.append('class'+str(class_idx))
            df=pd.DataFrame(index=index)

## 2.2 df ##

其中的元素的个数必须与index的元素的个数一样。

比如这种写法就会出现报错

df['weight'],df['precision'],df['recall'],df['F1']=[],[],[],[]
    '''
      File "badcase_analyse.py", line 180, in write_clases_result_into_html
        df['weight'],df['precision'],df['recall'],df['F1']=[],[],[],[]
      File "/home/xingxiangrui/chun-ML_GCN/env/lib/python3.6/site-packages/pandas/core/frame.py", line 3370, in __setitem__
        self._set_item(key, value)
      File "/home/xingxiangrui/chun-ML_GCN/env/lib/python3.6/site-packages/pandas/core/frame.py", line 3445, in _set_item
        value = self._sanitize_column(key, value)
      File "/home/xingxiangrui/chun-ML_GCN/env/lib/python3.6/site-packages/pandas/core/frame.py", line 3630, in _sanitize_column
        value = sanitize_index(value, self.index, copy=False)
      File "/home/xingxiangrui/chun-ML_GCN/env/lib/python3.6/site-packages/pandas/core/internals/construction.py", line 519, in sanitize_index
        raise ValueError('Length of values does not match length of index')
    ValueError: Length of values does not match length of index
    '''

所以我们先创建list再往里写

weight_list,precision_list,recall_list,F1_list=[],[],[],[]
            # df['weight'],df['precision'],df['recall'],df['F1']=[],[],[],[]
            self.cls_P, self.cls_R, self.cls_F1,self.cls_weight
            for class_idx in range(self.class_num):
                weight_list.append(self.cls_weight[class_idx])
                precision_list.append(self.cls_P[class_idx])
                recall_list.append(self.cls_R[class_idx])
                F1_list.append(self.cls_F1[class_idx])
            df['weight']=weight_list
            df['precision']=precision_list
            df['recall']=recall_list
            df['F1']=F1_list

## 2.3 写入html文件 ##

直接创建head与body，写入html文件

df['weight']=weight_list
            df['precision']=precision_list
            df['recall']=recall_list
            df['F1']=F1_list
            HEADER = '''
                <html>
                    <head>
                        <meta charset="UTF-8">
                    </head>
                    <body>
                '''
            FOOTER = '''
                    </body>
                </html>
                '''
            with open(self.html_path, 'w') as f:
                f.write(HEADER)
                f.write(df.to_html(classes='df'))
                f.write(FOOTER)

## 2.4 结果 ##

成功写入

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zNjQ3NDgwOQ_size_16_color_FFFFFF_t_70 1][]

# 三、例程 #

运算出王者荣耀护甲值与实际的伤害比例的关系

#!/usr/bin/python
    # -*- coding: UTF-8 -*-
    """
    运算王者荣耀装备机制
    """
    import numpy as np
    import matplotlib.pyplot as plt
    import math
    import pandas as pd
    
    ################  1.实际伤害比例与护甲值计算
    plt.figure(1)
    
    # 比例显示与运算
    AR=[]
    AD_ratio=[]
    
    AR_all=np.linspace(0,1500,10) # 0-1500之间的护甲值
    
    for AR_item in AR_all:
        AR.append(AR_item)
        AD_ratio.append(602/(602+AR_item)*100)
    
    # 画图显示
    plt.plot(AR,AD_ratio,marker='o')
    plt.xlim(0,1500)
    plt.grid( color = 'blue',linestyle='-',linewidth = 0.3)
    plt.ylim(0,100)
    
    for a, b in zip(AR, AD_ratio):
        a=round(a,0) #规定一位精度
        b=round(b,1)
        plt.text(a, b, (a,b),ha='center', va='bottom', fontsize=10)
    
    plt.title('护甲与AD伤害比例%', fontproperties="SimSun")
    plt.xlabel('AR护甲', fontproperties="SimSun")
    plt.ylabel('AD受到伤害比例', fontproperties="SimSun")
    #plt.show()
    
    # 表格显示
    
    AR=[]
    AD_ratio=[]
    ratio_decrese=[]
    AR_all=np.linspace(0,1500,10) # 0-1500之间的护甲值,第三个参数是值的数量
    for AR_item in AR_all:
        AR.append(round(AR_item,0))
        AD_ratio.append(round(602/(602+AR_item)*100,2))
        ratio_decrese.append(round((602/(602+AR_item)-602/(602+AR_item+100))*100,2))
    df = pd.DataFrame(index=AR)
    df["AD_ratio"]=AD_ratio
    df["ratio_decrese"]=ratio_decrese
    
    HEADER = '''
        <html>
            <head>
                <meta charset="UTF-8">
            </head>
            <body>
        '''
    FOOTER = '''
            <img src="%s" alt="" width="1200" height="600">
            </body>
        </html>
        '''
    with open("C:\\Users\\xingxiangrui\Desktop\\照片\\test.html", 'w') as f:
        f.write(HEADER)
        f.write(df.to_html(classes='df'))
        f.write(FOOTER)
    
    print("Program done!")

[https_blog.csdn.net_tz_zs_article_details_81137998]: https://blog.csdn.net/tz_zs/article/details/81137998
[http_pandas.pydata.org_pandas-docs_version_0.19.0_generated_pandas.DataFrame.to_html.html]: http://pandas.pydata.org/pandas-docs/version/0.19.0/generated/pandas.DataFrame.to_html.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zNjQ3NDgwOQ_size_16_color_FFFFFF_t_70]: /images/20220131/e2106ea325154b22afe4a4952a32ab6f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zNjQ3NDgwOQ_size_16_color_FFFFFF_t_70 1]: /images/20220131/21216820079d4a478fe23f56f329573e.png