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['进货量'].sum()

假设进货量等于销量

data['进货量'] = data['销量']

打印进货方案

print(data[['单品名称', '进货量']])