padas 生成excel 增加sheet表的實例

2020-01-04 13:51:52

字體：大中小

來源：轉載

供稿：網友

基本介紹

pandas是Python數據挖掘、數據分析中常用的庫。而DataFrame生成excel中的sheet表，以及在excel中增加sheet表，在數據分

析中也經常用到。這里以一個簡單例子介紹這兩個功能的用法，以備不時之需。

例子：

#!/usr/bin/env python# -*- coding: utf-8 -*-"""Version: 0.1Author: Wang PeiLicense: Copyright(c) 2017 Pei.WangSummary: (1)padas dataframe生成excel (2)excel中增加sheet表"""import sysimport pandas as pdfrom openpyxl import load_workbookreload(sys)sys.setdefaultencoding('utf-8')"""padas dataframe生成excel"""def dataFrame2sheet(dataframe,excelWriter): # DataFrame轉換成excel中的sheet表 dataframe.to_excel(excel_writer=excelWriter, sheet_name="info1",index=None) dataframe.to_excel(excel_writer=excelWriter, sheet_name="info2",index=None) dataframe.to_excel(excel_writer=excelWriter, sheet_name="info3",index=None) excelWriter.save() excelWriter.close()"""excel中新增sheet表"""def excelAddSheet(dataframe,excelWriter): book = load_workbook(excelWriter.path) excelWriter.book = book dataframe.to_excel(excel_writer=excelWriter,sheet_name="info5",index=None) excelWriter.close()if __name__ == '__main__': # 數據集 dataSet = [ {"姓名": "張三", "年齡": 23, "性別": "男"}, {"姓名": "李四", "年齡": 25, "性別": "男"}, {"姓名": "王五", "年齡": 21, "性別": "女"} ] # excelPath excelPath="G:/cmcm/ReportAuto//02TestData//x.xlsx" # 生成DataFrame dataframe = pd.DataFrame(dataSet) #創建ExcelWriter 對象 excelWriter=pd.ExcelWriter(excelPath,engine='openpyxl') # #生成excel #dataFrame2sheet(dataframe,excelWriter) #excel中增加sheet excelAddSheet(dataframe,excelWriter)

padas,excel,sheet