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.sort_values(by='进货量', ascending=False).head()

print("进货方案:") print(进货方案[['单品名称', '进货量']])