【python】表格合并时删除每列重复值，并分列汇总

import xlrd
import xlwt
from xlutils.copy import copy
import os

col_num = 2
sheet_num = 2


def create_excel(path, sheet_name):
    workbook = xlwt.Workbook()  # 新建一个工作簿
    workbook.add_sheet(sheet_name)  # 在工作簿中新建一个表格
    workbook.save(path)  # 保存工作簿


def read_data(FileName):
    # 1.打开文件
    open_file = xlrd.open_workbook(FileName)

    # 2.读取某个sheet的内容（第一个表索引值为0）
    st = open_file.sheet_by_index(2)
    # 提取某一列
    total_data = []
    i = 0
    while i < st.nrows:
        data = st.cell_value(i, 1)
        total_data.append(data)
        i += 1
    return total_data
    # 3.将表名追加到列表作为第一个元素

    return total_data


def del_repeat(list):
    L1 = []
    for i in list:
        if i not in L1:
            L1.append(i)
    return L1


def write_data(path, data):
    index = len(data)  # 获取索引写入的行数
    workbook = xlrd.open_workbook(path)  # 打开工作簿
    sheets = workbook.sheet_names()  # 获取工作簿中的所有表格
    wor