我有一个这样的数据框 -
我想要表格中这样的列-
所以决赛桌是这样的——
我如何计算这些列。
我在 django rest API 中有当前代码-
@api_view(['GET','POST'])
def sale_prod(request):
if request.method == 'GET':
data = sales_products.objects.values()
df = pd.DataFrame(data)
df = df.groupby(['item_id','item_code'])['amount','quantity'].sum().reset_index()
df.dropna(inplace=True)
df['amount_per'] = (df.amount / df.amount.sum())*100 # revenue contribution
df['quantity_per'] = (df.quantity / df.quantity.sum())*100 # unit sold contribution
df = df.round({'quantity': 0, 'amount':2, 'amount_per':2, 'quantity_per':2})
main_list = []
for ind in df.index:
dict1 = {}
dict1['item_code'] = df['item_code'][ind]
dict1['amount'] = df['amount'][ind]
dict1['quantity'] = df['quantity'][ind]
dict1['amount_per'] = df['amount_per'][ind]
dict1['quantity_per'] = df['quantity_per'][ind]
main_list.append(dict1)
return Response(main_list)
这段代码以数据框的形式给了我输出 -
amount_per = 按金额计算的项目贡献百分比
quantity_per = 按数量计算的项目贡献百分比
请帮我找出正确的答案。
神不在的星期二
相关分类