import pandas as pd

读取数据

data = pd.read_csv('data5.csv')

计算每种单品的收益和进货量

data['单品收益'] = data['销量'] * data['成本加成定价'] * (1 - data['单品损耗'] * 0.01) - data['销量'] * data['批发价格'] data['进货量'] = data['销量'] * (1 - data['单品损耗'] * 0.01)

按单品收益降序排序

data_sorted = data.sort_values(by='单品收益', ascending=False)

初始化进货方案

purchase_plan = {}

总收益

total_profit = 0

进货的单品总数

total_items = 0

遍历每种单品

for index, row in data_sorted.iterrows(): # 获取单品信息 item_id = row['单品编号'] item_profit = row['单品收益'] item_quantity = row['进货量']

# 判断是否还可以进货
if total_items + item_quantity <= 33:
    # 更新进货方案和总收益
    purchase_plan[item_id] = item_quantity
    total_profit += item_profit * item_quantity
    total_items += item_quantity

# 判断是否已经达到进货上限
if total_items == 33:
    break

print("进货方案：") for item_id, item_quantity in purchase_plan.items(): print(f"单品编号：{item_id}，进货量：{item_quantity}")

print(f"总收益：{total_profit}")