pandas处理excel文件处理，比较繁琐，需要的可以参考一下

import pandas as pd
import numpy as np
import time
import re
from pandas.core.frame import DataFrame
import copy


def new_sheet(filename):
    xlex = pd.ExcelFile(filename)
    writer = pd.ExcelWriter(filename)
    print('共' + str(len(xlex.sheet_names)) + '张表')
    print('原表读取中...')
    while True:
        try:
            for i in range(len(xlex.sheet_names)):
                all_df = pd.DataFrame(pd.read_excel(filename, xlex.sheet_names[i]))
                all_df.to_excel(writer, xlex.sheet_names[i], index=False)
                print('第' + str(i + 1) + '个表读取完毕')
            writer.save()
            writer.close()
            print('表格已全部读取完毕，请继续您的操作！')
            break
        except:
            times = 5
            print('{}s后从新刷新，请关闭需要操作的excel表格'.format(times))
            time.sleep(times)
            continue
    while True:
        print(xlex.sheet_names)
        sheet = input('请选择想要操作的表格：')  # 查询出文件中所有的表格名
        if sheet in xlex.sheet_names:
            df = pd.read_excel(filename, sheet)  # index_col 处理从哪列开始，下标
            break
        else:
            print('只能操作已经存在的表格哦,请选择已经存在的表！')
            continue
    while True:
        columns = list(df.columns.values)  # 头信息数据
        print(columns)
        check_col = input('选择想要去重的列：（一次仅可选择一列进行去重操作）').split()
        if len(check_col) > 1:
            print('去重列只支持单列去重哦！！！')
            continue
        else:
            check_col = check_col[0]
            if check_col in columns:
                col_index = columns.index(check_col)
                break
            else:
                print('请检查选择的列是否在备选方案中！！！')
                continue
    all_list = list(df.iloc[:, col_index