替换表格内容及csv转html
替换指定内容
现在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)
运行结果
SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。
代码
# -*- 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()
运行结果展示
更多精彩
