现在excel中替换再将替换的内容转换成CSV格式
# -*- Coding: utf-8 -*-"""Created on Mon Apr 29 10:36:01 2019@author: 18605"""import pandas as pddf=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 EditorThis is a temporary script file."""#e13.1csvHTML.py# enCoding: utf-8# -*- Coding:utf-8seg1=‘‘‘<!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 EditorThis is a temporary script file."""#e13.1csvHTML.py# enCoding: utf-8# -*- Coding:utf-8seg1=‘‘‘<!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","") ls.append(line.split(",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全部内容，希望文章能够帮你解决替换表格内容及csv转html所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）