赞
踩
一、按某一列分类拆分成sheet文件
- #!/usr/bin/env python
- # -*- coding: UTF-8 -*-
- #-*-coding:gb2312 -*-
- import sys
- reload(sys)
- sys.setdefaultencoding('utf8')
-
-
- from openpyxl import load_workbook
- import pandas as pd
- import numpy as np
- IO='C:\\Users\\23898\\Desktop\\1.xlsx'
-
- def _excelAddSheet(dataframe,excelWriter,sheet_name):
- book = load_workbook(excelWriter.path)
- excelWriter.book = book
- dataframe.to_excel(excel_writer=excelWriter,sheet_name=sheet_name,index=None)
- excelWriter.close()
-
-
-
- if __name__ == '__main__':
- df=pd.read_excel(IO)
- writer = pd.ExcelWriter(IO)
- excelWriter = pd.ExcelWriter(IO,engine='openpyxl')
- data=df.ix[:,['部门(栏目)']].values#读所有行的title以及data列的值,这里需要嵌套列表
-
-
- DepartmentList=[]
- for department in data:
- if department in DepartmentList:
- # print(department)
- pass
- elif department[0]

赞
踩
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。