【Python】xlwings-删除重复行
样本数据:需要将根据参数1将参数2合并,并以分号;作为分隔符,最后删除多余行# !/user/bin/env python# -*- coding: utf-8 -*-"""==================================================@author: cyairhp@time: 2021/4/1 0:10@file: unrepeat.py@desc: 根据
·
样本数据:
需要将根据参数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('导出成功!')
运行结果:
更多推荐
已为社区贡献2条内容
所有评论(0)