拆分&合并工作薄或工作表

1.按某些列将一个sheet拆分为多个xlsx

import pandas as pd
fp1 = 'C:\\Users\\仙君\\Desktop\\销售表.xlsx'
fp2 = 'C:\\Users\\仙君\\Desktop\\拆分\\'
df = pd.read_excel(fp1,sheet_name='总表')
fz_data = df.groupby('产品名称')
for i,j in fz_data:
    nfp = fp2 + i + '.xlsx'
    j.to_excel(nfp,sheet_name=i,index=False)

2. 按某些列将一个sheet拆分为多个sheet

import pandas as pd
fp1 = 'C:\\Users\\仙君\\Desktop\\销售表.xlsx'
fp2 = 'C:\\Users\\仙君\\Desktop\\各产品销售表.xlsx'
df = pd.read_excel(fp1,sheet_name='总表')
fz_data = df.groupby('产品名称')
with pd.ExcelWriter(fp2) as wb:
    for i,j in fz_data:
        j.to_excel(wb,sheet_name=i,index=False)

3.同一工作薄纵向合并多个sheet为一个sheet

import pandas as pd
fp1 = 'C:\\Users\\仙君\\Desktop\\上半年销售统计.xlsx'
fp2 &