深更半夜 - excel办公自动化定制版

import pandas as pd

# 读取excel数据，将数据放入列表,
表格数据 = pd.read_excel("limin.xlsx", sheet_name=0)
ship_no = 表格数据.keys()[3]
sup_amount = 表格数据.keys()[-1]
ship_no_value = 表格数据[ship_no].values
sup_amount_value = 表格数据[sup_amount].values
list_ship_no_value = list(ship_no_value)
list_sup_amount_value = list(sup_amount_value)

cache = {}
for index, number in enumerate(list_ship_no_value):
    if number not in cache:
        cache[number] = {"sum": list_sup_amount_value[index], "count": 1}
    else:
        cache[number]["sum"] += list_sup_amount_value[index]
        cache[number]['count'] += 1
li1 = []
for item in cache.items():
    li1.append(item[1]['sum'])
English = li1
data1 = {sup_amount: English}
a = pd.DataFrame(data1)

# 根据ship_no列，删除重复行，保留第一行，不删除所有重复项
表格数据.drop_duplicates(subset=[ship_no],keep='first',inplace=True)
# 删除列
del 表格数据[sup_amount]
# 新增列
表格数据[sup_amount] = li1
# 生成数据，数据居中
表格数据.to_excel("丽敏定制版.xlsx", index=False)