with实现闭环管理,否则可能会遗忘后半截
案例:把数据保存在本地同一表格不同excel中
#保存数据于已存在的excel中的不同sheet页中
writer=pd.ExcelWriter('json_all.xlsx')#j本地son_all.xlsx需存在
data_json_all.to_excel(writer,'Shee2')
data_json_all.to_excel(writer,'Shee3')
writer.save()#容易被遗忘
#使用with后
with pd.ExcelWriter('json_all.xlsx') as writer:
data_json_all.to_excel(writer,'Shee2')
data_json_all.to_excel(writer,'Shee3')
#其他:保存在excel中,不区分sheet
data_json_all.to_excel('json_all.xlsx')