1对文件读写操作

操作"/>

1对文件读写操作

1最基本的文件读写txt

1.1读取txt

    path=r'D:\MyPython\Pystudy\file\lbj.txt'f=open(path)print(f.read())f.close()

1.2追写txt

def file_txt_write():path=r'D:\MyPython\Pystudy\file\lbj.txt'f = open(path,'a+')f.read()f.write('\n我很喜欢詹姆斯')f.close()

2读写csv

2.1读取csv

    path=r'D:\MyPython\Pystudy\file\all.csv'mdata=pd.read_csv(path,encoding='gbk')print(mdata.head())

2.2写csv

data = pandas.DataFrame(list(mdata))
data.to_csv(path)

3读写excel

3.1读取excel

    path=r'D:\MyPython\Pystudy\file\all.xlsx'mdata=pd.read_excel(path,encoding='gbk',sheet_name='allsheet')print(mdata.head(6))

3.2写excel

writer = pd.ExcelWriter(path)
data = pd.DataFrame(columns=['列名1','列名2','列名3','列名4'],data=mydata) 
data.to_excel(writer,index=True)#有无index
#data.to_excel(writer,'Sheet1')#可以命名表名
writer.save()
writer.close()

data = pd.DataFrame(columns=['列名1','列名2','列名3','列名4'],data=mydata) 
data.to_excel(writer,index=True)#有无index