变量在特定水平上的平均值

Question

我有这个数据集，我只想要'Category' = 'Italian'的'Price'列的平均值

df.head()
Price   Category
10.5    Italian
32.4    Filipino
56.8    Sushi
8.45    Italian
meanprice = df.groupby('Category').mean()

然后我发现没有办法做一个简单的

meanita= df.loc['Category' == 'Italian']

Answer 1

试试这个:

df.loc[df['Category'] == 'Italian', 'Price'].mean()
# 9.475