Python同時導出多個Excel工作表

從 YTYZX有图有真相的百科
跳到: 導覽搜尋
1.with pd.ExcelWriter(r'C:\GITPythonLesson\exportdata.xlsx',engine='xlsxwriter') as writer:
      dfnew['统计结果'].value_counts().sort_index().to_excel(writer,sheet_name='次数统计')
      df10['统计结果'].value_counts().sort_index().to_excel(writer,sheet_name='10')
      df20['统计结果'].value_counts().sort_index().to_excel(writer,sheet_name='20')
      df30['统计结果'].value_counts().sort_index().to_excel(writer,sheet_name='30')
      df40['统计结果'].value_counts().sort_index().to_excel(writer,sheet_name='40')
      writer.save()