替换表格内容及csv转html及CGI

替换指定内容

现在excel中替换再将替换的内容转换成CSV格式

# -*- coding: utf-8 -*-
"""
Created on Mon Apr 29 10:36:01 2019

@author: 18605
"""

import pandas as pd
df=pd.read_excel("D:\张香婷\python\Python1.xlsx",index_col=None,na_values=['dgf'])
line=df.replace("\n","")
line=line.replace("优秀","90")
line=line.replace("良好","80")
line=line.replace("合格","60")
line=line.fillna(value=0)
line.to_csv('D:\张香婷\python\Python2.csv',encoding="utf_8_sig")
print(line)

运行结果

代码

# -*- coding: utf-8- -*-
"""
Spyder Editor

This is a temporary script file.
"""

#e13.1csvhtml.py
# encoding: utf-8
# -*- coding:utf-8
seg1='''
<!DOCTYPE HTML>\n<html>\n<body>\n<mata charset=gb2312>
<h2 align=center>18信计二班python成绩统计表</h2>
<table border='1' align="center" width=70%>
<tr bgcolor='orange'>\n'''
seg2="</tr>\n"
seg3="</table>\n</body>\n</html>"
def fill_data(locls):
# ======================= NO.3 7个就够了 ======================
    seg='<tr><td align="center">{}</td><td align="center">\
    {}</td><td align="center">{}</td><td align="center">\
    {}</td><td align="center">{}</td><td align="center">\
    {}</td><td align="center">{}</td><td align="center">\
    '.format(*locls)
    #{}</td><td align="center">{}</td><td align="center">{}</td></tr>\n
    return seg

# ========================== NO.1 修改encoding ==============================
fr=open("python2.csv","r", encoding="utf-8")
ls=[]
for line in fr:
    line=line.replace("\n",""))
    ls.append(line.split(","))
fr.close()
# ========================== NO.2 增加encoding ==============================
fw=open("Python123.html","w", encoding="utf-8")
fw.write(seg1)
# =================== NO.4 修改表格宽度 ========================
fw.write('<th width="10%">{}</th>\n<th width="15%">{}</th>\n<th width="15%">{}</th>\n\
<th width="15%">{}</th>\n<th width="15%">{}</th>\n\
<th width="15%">{}</th>\n<th width="15%">{}</th>\n'.format(*ls[0]))
fw.write(seg2)
for i in range(len(ls)-1):
    fw.write(fill_data(ls[i+1]))
fw.write(seg3)
fw.close()

运行结果

csv转html

代码

# -*- coding: utf-8- -*-
"""
Spyder Editor

This is a temporary script file.
"""

#e13.1csvhtml.py
# encoding: utf-8
# -*- coding:utf-8
seg1='''
<!DOCTYPE HTML>\n<html>\n<body>\n<mata charset=gb2312>
<h2 align=center>18信计二班python成绩统计表</h2>
<table border='1' align="center" width=70%>
<tr bgcolor='orange'>\n'''
seg2="</tr>\n"
seg3="</table>\n</body>\n</html>"
def fill_data(locls):
# ======================= NO.3 7个就够了 ======================
    seg='<tr><td align="center">{}</td><td align="center">\
    {}</td><td align="center">{}</td><td align="center">\
    {}</td><td align="center">{}</td><td align="center">\
    {}</td><td align="center">{}</td><td align="center">\
    '.format(*locls)
    #{}</td><td align="center">{}</td><td align="center">{}</td></tr>\n
    return seg

# ========================== NO.1 修改encoding ==============================
fr=open("python1.csv","r", encoding="utf-8")
ls=[]
for line in fr:
    line=line.replace("\n","")
    ls.append(line.split(","))
fr.close()
# ========================== NO.2 增加encoding ==============================
fw=open("Python123.html","w", encoding="utf-8")
fw.write(seg1)
# =================== NO.4 修改表格宽度 ========================
fw.write('<th width="10%">{}</th>\n<th width="15%">{}</th>\n<th width="15%">{}</th>\n\
<th width="15%">{}</th>\n<th width="15%">{}</th>\n\
<th width="15%">{}</th>\n<th width="15%">{}</th>\n'.format(*ls[0]))
fw.write(seg2)
for i in range(len(ls)-1):
    fw.write(fill_data(ls[i+1]))
fw.write(seg3)
fw.close()

运行结果展示

CGI

CGI（Common Gateway Interface）也叫通用网关接口，它是一个web服务器主机提供信息服务的标准接口，只要遵循这个接口，web服务器就能获取客户端提交的信息，转交给服务端的CGI程序进行处理，然后将处理结果返回给客户端。CGI通讯是由两部分组成的：一部分是用户的浏览器显示的页面，也就是html页面，另一部分则是运行在服务器上的CGI程序。它们之间的通讯方式如下图所示：