求从总表分出分表代码

ericxzhou

Python+Pandas:
import pandas as pd

df = pd.read_excel('pandas exercise/sample472.xlsx', '总表', usecols='a:e')
wb = pd.ExcelWriter('pandas exercise/Sample472_results.xlsx')
for name, group in df.groupby('产品名称', as_index=False):
    group.to_excel(wb, name, index=False)
wb.close()