将工作薄按列拆分至工作薄 2023-03-27 阅读次数：

import pandas as pd
data = pd.read_excel(r'地址\汇总.xls',keep_default_na=False)
unit_list = list(data['姓名'].drop_duplicates())
for i in unit_list:
	data_new = data[data['姓名'] == i]
	if i == '':
		data_new.to_excel()
	else:
		data_new.to_excel(r"地址\%s.xls" % (i),index=False)