一、按某一列分类拆分成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]