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)

按单品收益降序排序

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

初始化进货方案

purchase_plan = {} total_profit = 0

贪婪算法

for index, row in sorted_data.iterrows(): item = row['单品编号'] quantity = row['销量']

# 判断是否已经进货过该单品
if item not in purchase_plan:
    purchase_plan[item] = quantity
    total_profit += row['单品收益']
    
# 判断进货量是否超过销量
elif purchase_plan[item] < quantity:
    total_profit -= purchase_plan[item] * row['单品收益']
    purchase_plan[item] = quantity
    total_profit += row['单品收益']

输出进货方案和总收益

print("进货方案：") for item, quantity in purchase_plan.items(): print("单品编号：{}，进货量：{}".format(item, quantity)) print("总收益：", total_profit)