pandas 读写excel

pandas 读写excel

>>>import pandas as  pd

>>> 
excel_path = r"C:\Users\Administrator\Desktop\R2003063 - MTO--B16.11.xlsx"

>>> data=pd.read_excel(excel_path)
>>> writer=pd.ExcelWriter(r"C:\Users\Administrator\Desktop\R2003063 - MTO--B16.111.xlsx")
>>> data.to_excel(writer,'sheet1',index=False)
>>> writer.save()
>>> writer=pd.ExcelWriter(r"C:\Users\Administrator\Desktop\R2003063 - MTO--B16.112.xlsx")
>>> data.to_excel(writer,'sheet1',index=False)
>>> writer.save()
>>> 

参考：https://blog.youkuaiyun.com/jingyi130705008/article/details/100741205