如何将Pandas中的两列分组并将另外两列相乘为一个新列?

在分组之前,首先计算价格*数量会更容易:

import pandas as pd

df = pd.DataFrame({
    'Price': [3.0, 1.2, 0.6, 1.12, 2.0],
    'Quantity': [10, 50, 30, 40, 20],
    'FoodTruck': ['Burgers', 'Tacos', 'Tacos', 'Drinks', 'Burgers'],
    'FoodTruck_ID': [1, 2, 2, 4, 1]
})

df['Revenue'] = df['Price']*df['Quantity']

df.groupby(['FoodTruck','FoodTruck_ID'])['Revenue'].sum()

输出

FoodTruck  FoodTruck_ID
Burgers    1               70.0
Drinks     4               44.8
Tacos      2               78.0
Name: Revenue, dtype: float64