"Python同时导出多个Excel工作表" 修訂間的差異
出自 YTYZX有图有真相的百科
(创建页面,内容为“ 1.with pd.ExcelWriter(r'C:\GITPythonLesson\exportdata.xlsx') as writer: dfnew['统计结果'].value_counts().sort_index().to_excel(writer,sheet_name='次数...”) |
|||
行 1: | 行 1: | ||
− | 1.with pd.ExcelWriter(r'C:\GITPythonLesson\exportdata.xlsx') as writer: | + | 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() |
於 2022年10月6日 (四) 20:57 的最新修訂
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()