【Python 01】工作小妙招（按条件拆分excel四步走）

import pandas as pd
import xlrd

data = pd.read_excel(r"D:xxxxxxxxx等待拆分的表.xlsx")

area_list = list(set(data['分类字段名称']))

for i in area_list:
	# 创建一个表格
    writer = pd.ExcelWriter(r"D:xxxxxxxxx{}分类拆分完成.xlsx".format(i), engine='xlsxwriter')
    # 分类拆分原表格数据
    df = data[data['分类'] == i]
    # 储存excel
    df.to_excel(writer, sheet_name="{}分类拆分完成".format(i), index=False)
    writer.save() 

快来试试吧~