1、实现紧接着一个excel文件向后写的办法
#encoding=utf-8 import pandas as pd import numpy as np import xlrd # - 副本 #读调查表→getframe1→读保存文件→getframe2→结合两者→存入保存文件 rawexcel_path = 'D:\CEKIOSK\dataframe\yu1\鱼山校区鸟类调查表一20180426.xlsx' def rawdt_deal(excel_path): d=pd.read_excel(excel_path,sheetname='Sheet1',names=['variety','num','variety','num','variety','num','7','8'],header=None) aa=d.iloc[5:,0:2]#鸟类数量+鸟类名 aa2=d.iloc[5:,2:4] aa3=d.iloc[5:,4:6] date=d.iloc[0,1] weather=d.iloc[0,3] temper=d.iloc[0,5] t_s=d.iloc[1,3] t_e=d.iloc[1,5] route='yu'+str(d.iloc[1,1]) dd=aa[aa.num!='、']#服了!! cc=dd[dd.num>0] print(cc) print(date) cc['date']=date cc['weather']=weather cc['temper']=temper cc['t_s']=t_s cc['t_e']=t_e cc['route']=route return cc #程序开始 ##处理新表 newframe=rawdt_deal(rawexcel_path) print(newframe) ##读取存在表 existframe=pd.read_excel('D:\CEKIOSK\dataframe\\final1.xlsx',sheetname='Sheet1') #结合两者 finalframe=pd.concat([newframe,existframe]) #写表 writer=pd.ExcelWriter('D:\CEKIOSK\dataframe\\text.xlsx') finalframe.to_excel(writer,sheet_name='Sheet1') writer.save()
#读调查表→getframe1→读保存文件→getframe2→结合两者→存入保存文件
2、为什么写入excel时候permission denied:因为excel文件还开着
3、连接dataframe的方法
https://blog.csdn.net/milton2017/article/details/54406482