[已解决]如何把用pandas生成的两份数据同时保存到一个excel表格里的两个sheet中

拽猫的尾巴

我生成了两份数据：df1，df2；
我想把这两份数据同时保存到一个excel表格里的两个sheet中，并把sheet名改成df1，df2。

1. 
   
2. import pandas as pd
   
3. import numpy as np
   
4. 
   
5. df1 = pd.DataFrame(np.arange(24).reshape((6,4)), columns = ['A','B','C','D'])
   
6. df2 = pd.DataFrame(np.arange(12).reshape((3,4)), columns = ['A','B','C','D'])
   

复制代码

最佳答案

月排行榜 / 总排行榜

逃兵

2021-9-15 11:49:43

1. 
   
2. import pandas as pd
   
3. import numpy as np
   
4. 
   
5. df1 = pd.DataFrame(np.arange(24).reshape((6,4)), columns = ['A','B','C','D'])
   
6. df2 = pd.DataFrame(np.arange(12).reshape((3,4)), columns = ['A','B','C','D'])
   
7. path = 'test.xlsx'
   
8. writer = pd.ExcelWriter(path)
   
9. df1.to_excel(excel_writer = writer,sheet_name = 'df1')
   
10. df2.to_excel(excel_writer = writer,sheet_name = 'df2')
    
11. writer.save()
    
12. writer.close()
    

复制代码

跳转到最佳答案楼层

逃兵

1. 
   
2. import pandas as pd
   
3. import numpy as np
   
4. 
   
5. df1 = pd.DataFrame(np.arange(24).reshape((6,4)), columns = ['A','B','C','D'])
   
6. df2 = pd.DataFrame(np.arange(12).reshape((3,4)), columns = ['A','B','C','D'])
   
7. path = 'test.xlsx'
   
8. writer = pd.ExcelWriter(path)
   
9. df1.to_excel(excel_writer = writer,sheet_name = 'df1')
   
10. df2.to_excel(excel_writer = writer,sheet_name = 'df2')
    
11. writer.save()
    
12. writer.close()
    

复制代码