python - 在 Pandas Dataframe 中创建总计行

Question

因此，我试图在我的数据框中创建一个新行，该行仅将 AB 和 C 列的总和相加，并具有 D 和 E 列的方法。我尝试过执行以下操作：

df.loc['totals'] = df['daily budget', 'weekly budget', 'monthly budget'].sum() + df['average spent monthly','average spent yearly'].mean()

它没有用。我是否应该尝试通过执行类似的操作来定义每个值

sum1 = df['daily budget'].sum()
sum2 = df['weekly budget'].sum()
sum3 = ....
mean1 =df['average monthly'].mean()
mean2 = ....

并填写单元格？

标签： pythonpandas

Answer 1

如果您想采用您的方法，那么这应该可行。

sum1 = df['daily budget'] + df['weekly budget'] + df['monthly budget']

mean1 = (df['average spent monthly'] + df['average spent yearly'])/2

df['total'] = sum1 + mean1