将excel数据分到不同的sheet中

import pandas as pd

df = pd.read_excel("all_faq.xlsx")
washer = pd.DataFrame()  # 洗衣机
vacuum_cleaner = pd.DataFrame()  # 吸尘器
Water_purifier = pd.DataFrame()  # 净水器
fan = pd.DataFrame()  # 电风扇
Lock = pd.DataFrame()  # 门锁
Clothes_dryer = pd.DataFrame()  # 晾衣机
Electric_heaters = pd.DataFrame()  # 点暖器
Air_disinfection_machine = pd.DataFrame()  # 空气消毒机
Floor_scrubbers = pd.DataFrame()  # 洗地机
rice_cooker = pd.DataFrame()  # 电饭煲
Humidifier = pd.DataFrame()  # 加湿器
Spotlights = pd.DataFrame()  # 射灯
HomePad = pd.DataFrame()
router = pd.DataFrame()  # 路由器

for i in df.index:
    if '洗衣机' in df['文档来源'][i]:
        washer = pd.concat([washer, df.iloc[i, :]], axis=1)

    elif '洗烘一体机' in df['文档来源'][i]:
        washer = pd.concat([washer, df.iloc[i, :]], axis=1)

    elif '吸尘器' in df['文档来源'][i]:
        vacuum_cleaner = pd.concat([vacuum_cleaner, df.iloc[i, :]], axis=1)

    elif '净水器' in df['文档来源'][i]:
        Water_purifier = pd.concat([Water_purifier, df.iloc[i, :]], axis=1)

    elif '电风扇' in df['文档来源'][i]:
        fan = pd.concat([fan, df.iloc[i, :]], axis=1)

    elif '落地扇' in df['文档来源'][i]:
        fan = pd.concat([fan, df.iloc[i, :]], axis=1)

    elif '门锁' in df['文档来源'][i]:
        Lock = pd.concat([Lock, df.iloc[i, :]], axis=1)

    elif '晾衣机' in df['文档来源'][i]:
        Clothes_dryer = pd.concat([Clothes_dryer, df.iloc[i, :]], axis=1)

    elif '晾衣架' in df['文档来源'][i]:
        Clothes_dryer = pd.concat([Clothes_dryer, df.iloc[i, :]], axis=1)

    elif '点暖气' in df['文档来源'][i]:
        Electric_heaters = pd.concat([Electric_heaters, df.iloc[i, :]], axis=1)

    elif '电暖器' in df['文档来源'][i]:
        Electric_heaters = pd.concat([Electric_heaters, df.iloc[i, :]], axis=1)

    elif '空气消毒机' in df['文档来源'][i]:
        Air_disinfection_machine = pd.concat([Air_disinfection_machine, df.iloc[i, :]], axis=1)

    elif '洗地机' in df['文档来源'][i]:
        Floor_scrubbers = pd.concat([Floor_scrubbers, df.iloc[i, :]], axis=1)

    elif '电饭煲' in df['文档来源'][i]:
        rice_cooker = pd.concat([rice_cooker, df.iloc[i, :]], axis=1)

    elif '加湿器' in df['文档来源'][i]:
        Humidifier = pd.concat([Humidifier, df.iloc[i, :]], axis=1)

    elif '射灯' in df['文档来源'][i]:
        Spotlights = pd.concat([Spotlights, df.iloc[i, :]], axis=1)

    elif 'HomePad' in df['文档来源'][i]:
        HomePad = pd.concat([HomePad, df.iloc[i, :]], axis=1)

    else:
        router = pd.concat([router, df.iloc[i, :]], axis=1)



# 将多个sheet保存至同一个excel中
writer = pd.ExcelWriter('拆分表格.xlsx')
washer.T.to_excel(writer, index=False, sheet_name='洗衣机')
vacuum_cleaner.T.to_excel(writer, index=False, sheet_name='吸尘器')
Water_purifier.T.to_excel(writer, index=False, sheet_name='净水器')
fan.T.to_excel(writer, index=False, sheet_name='电风扇')
Lock.T.to_excel(writer, index=False, sheet_name='门锁')
Clothes_dryer.T.to_excel(writer, index=False, sheet_name='晾衣架')
Electric_heaters.T.to_excel(writer, index=False, sheet_name='电暖气')
Air_disinfection_machine.T.to_excel(writer, index=False, sheet_name='空气消毒机')
Floor_scrubbers.T.to_excel(writer, index=False, sheet_name='洗地机')
rice_cooker.T.to_excel(writer, index=False, sheet_name='电饭煲')
Humidifier.T.to_excel(writer, index=False, sheet_name='加湿器')
Spotlights.T.to_excel(writer, index=False, sheet_name='射灯')
HomePad.T.to_excel(writer, index=False, sheet_name='HomePad')
router.T.to_excel(writer, index=False, sheet_name='路由器')
writer.save()

原文地址：http://www.cnblogs.com/tiansz/p/16875365.html