当前位置:   article > 正文

python制作excel分表(按照某一列分类拆分)(一)_load workbook按列分组生辰xlsx

load workbook按列分组生辰xlsx

一、按某一列分类拆分成sheet文件

  1. #!/usr/bin/env python
  2. # -*- coding: UTF-8 -*-
  3. #-*-coding:gb2312 -*-
  4. import sys
  5. reload(sys)
  6. sys.setdefaultencoding('utf8')
  7. from openpyxl import load_workbook
  8. import pandas as pd
  9. import numpy as np
  10. IO='C:\\Users\\23898\\Desktop\\1.xlsx'
  11. def _excelAddSheet(dataframe,excelWriter,sheet_name):
  12. book = load_workbook(excelWriter.path)
  13. excelWriter.book = book
  14. dataframe.to_excel(excel_writer=excelWriter,sheet_name=sheet_name,index=None)
  15. excelWriter.close()
  16. if __name__ == '__main__':
  17. df=pd.read_excel(IO)
  18. writer = pd.ExcelWriter(IO)
  19. excelWriter = pd.ExcelWriter(IO,engine='openpyxl')
  20. data=df.ix[:,['部门(栏目)']].values#读所有行的title以及data列的值,这里需要嵌套列表
  21. DepartmentList=[]
  22. for department in data:
  23. if department in DepartmentList:
  24. # print(department)
  25. pass
  26. elif department[0]
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/酷酷是懒虫/article/detail/910147
推荐阅读
相关标签
  

闽ICP备14008679号