1、文件的读取

调用open()函数，返回一个File对象；   fp = open('D:/123/Test.txt', 'w'）

调用File对象的read()或write()方法；     fp.write('HelloWorld')

调用File对象的close()方法，关闭该文件。  fp.close()

#目录操作

import os

#创建目录

os.mkdir('D:/Test/')

#删除目录

os.rmdir('D:/Test/')

2、将excel改为csv格式

# -*- coding: utf-8 -*-

"""

Created on Mon May 6 11:08:37 2019

@author: 小米

"""

import pandas as pd

def ExcelToCsv_1(StartName, SheetName, EndName):

grade = pd.read_excel(StartName, sheet_name=SheetName)

for i in range(len(grade.index)):

for j in range(1, len(grade.columns)):

if grade.iloc[i, j] == '优秀':

grade.iat[i, j] = 90

elif grade.iloc[i, j] == '良好':

grade.iat[i, j] = 80

elif grade.iloc[i, j] == '合格':

grade.iat[i, j] = 60

else:

grade.iat[i, j] = 0

grade.to_csv(EndName)

def ExcelToCsv_2(StartName, SheetName, EndName):

grade = pd.read_excel(StartName, sheet_name=SheetName)

Grade = grade.replace("优秀", "90")

Grade = Grade.replace("良好", "80")

Grade = Grade.replace("不合格", "60")

Grade = Grade.replace("合格", "60")

Grade = Grade.fillna(value = 0)

Grade.to_csv(EndName)

ExcelToCsv_2('D:/Users/小米/Desktop/Python成绩登记信计.xlsx', 'Sheet1', 'D:/Users/小米/Desktop/Python成绩登记信计.csv')

ExcelToCsv_1('D:/Users/小米/Desktop/Python成绩.xlsx','Sheet2' ,'D:/Users/小米/Desktop/Python成绩.csv')