一个按姓名拆分Excel成多个sheet的小程序

import numpy as np
import pandas as pd
import xlrd
from openpyxl import load_workbook

from xlwt import *



# f_name_old = '统计结果.xlsx'
f_path=input("请输入地址：")

# f_path = "1.按名字拆分/" + f_name_old
f_name = f_path[:f_path.rfind('.')]
out_f_name = f_name + '_拆分完成.xlsx'

# 注意文件格式
data = pd.read_excel(f_path, dtype="str", encoding='utf8')

data.出 = data.出.astype(float)
data.进 = data.进.astype(float)
data.进出差额 = data.进出差额.astype(float)
data.出进差额 = data.出进差额.astype(float)

#data.交易名称 = data.交易名称.astype(str)
data.jymc = data.jymc.astype(str)


JYMCs = list(data.jymc.values)
JYMCs_dorp_repet_list = []
for i in JYMCs:
    if i not in JYMCs_dorp_repet_list:
        JYMCs_dorp_repet_list.append(i)

count = 0
# for i in list(set(data.JYMC.values)):
for i in JYMCs_dorp_repet_list:
    print(i)

    if count % 29 == 0:
        out_f_name = f_name + "_" + str(count // 29) + '_拆分完成.xlsx'
        data.to_excel(out_f_name, index=False)
    count += 1
    # 注意匹配字段
    data_name = data[data.jymc == i]
    writer = pd.ExcelWriter(out_f_name, engine='openpyxl')  # 可以向不同的sheet写入数据
    book = load_workbook(out_f_name)
    writer.book = book
    data_name.to_excel(writer, sheet_name=i, index=False)  # 将数据写入excel中的sheet2表,sheet_name改变后即是新增一个sheet
    writer.save()  # 保存
print("--------完成--------")