rename()方法
rename()方法有两个参数,即当前的文件名和新的文件名。
二,csv转html
代码如下:
# -*- coding: utf-8 -*-
"""
Created on Mon May 6 11:01:31 2019
@author: ABC
"""
import pandas as pd
df = pd.read_excel('Python_1.xlsx')
da = df.to_csv('D:\Anaconda\Python_1.csv')
da = pd.read_csv('D:\Anaconda\Python_1.csv',index_col=0)
da = da.replace('优秀','90')
da = da.replace('良好','80')
da = da.replace('合格','60')
da = da.replace('不合格','0')
da = da.fillna(0)
print(da)
dc = da.to_csv('D:\Anaconda\Python_1.csv')
seg1 = '''
\n\n
\nPython_1
seg2="
\n"seg3=