合并前:
合并后:
代码:
import pandas as pdimport openpyxldf = pd.read_excel("/Users/Desktop/AAA.xlsx")v_c = df["字段1"].value_counts()# 获取每个要合并的单元格内容有多少行dic_counts = dict(v_c)# 转成字典类型wb = openpyxl.load_workbook("/Users/Desktop/AAA.xlsx")# 使用openpyxl打开xlsx表格ws = wb.activerow = 2# xlsx表格内容从第2行开始while ws.cell(row, 1).value is not None:# 要合并的单元格是第1列,所以从ws.cell(row, 1).value开始counts = dic_counts[ws.cell(row, 1).value]# 获取当前单元格内容的数量ws.merge_cells(start_row=row, start_column=1, end_row=row + counts - 1, end_column=1)# 执行合并row = row + counts# 更新row,循环从合并后的下一格开始wb.save("/Users/wipas/Desktop/AAA1.xlsx")# 保存文件