python按某列拆分excel表格_[Python与数据分析]-1将Excel文件按某一列的值拆分成一系列独立的Excel文件...

import pandas as pd

import xlsxwriter

from xlwt import Workbook

data=pd.read_excel(r'****待拆分文件路径******.xlsx',encode='gbk')

area_list=list(set(data[u'*****列名称***']))

for j in area_list:

file_name = str(j)

file_route = "****拆分后文件保存路径*****" + str(j) + ".xls"

book = Workbook(encoding='utf-8')

sheet1 = book.add_sheet('Sheet2')

book.save(file_route)

writer=pd.ExcelWriter(file_route,engine='xlsxwriter')

df=data[data[u'*****列名称******']==j]

df.to_excel(file_route,sheet_name="Sheet1",index=False)

print("DONE!")