【Python】xlwings-删除重复行

样本数据：

需要将根据参数1将参数2合并，并以分号;作为分隔符，最后删除多余行

# !/user/bin/env python
# -*- coding: utf-8 -*-
"""==================================================
@author: cyairhp
@time  : 2021/4/1 0:10
@file  : unrepeat.py
@desc  : 根据分组合并同个分组的某列值，替换掉原来的值，删除重复行
=================================================="""

import pandas as pd
import xlwings as xw

path = r'E:\python\培训课件\p6-常用文件处理\code\unrepeat.xls'
save_path = r'E:\python\培训课件\p6-常用文件处理\code\unrepeat.xls_out.xls'

app = xw.App(visible=False, add_book=False)
app.display_alerts = False
app.screen_updating = False  # 是否实时刷新excel程序的显示内容
wb = app.books.open(path)
ws = wb.sheets[0]

# 获取行数
df = pd.read_excel(path, header=0)
row_num = len(df)


job_dict = {}  # 前置：[本身作业集合]
del_list = []
for i in range(row_num):
    if ws[i+1, 0].value in job_dict:
        job_dict[ws[i+1, 0].value].append(ws[i+1, 1].value)
        del_list.append(i+1)
    else:
        job_dict[ws[i + 1, 0].value] = [str(ws[i+1, 1].value)]

for i in range(row_num):
    ws[i+1, 1].value = ';'.join(job_dict[ws[i+1, 0].value])

# 删除多余行
for n in del_list:
    ws[n, 0:].delete()

wb.save(save_path)
wb.close()
app.quit()

print('导出成功！')

运行结果：