r - 将行与平均值相结合

Question

我有一个这样的数据框

customer_id<-c("aks123","epfk123","jfk1234","ekdm453","ddd4356","epfk123","ffg234","aks123","jfk1234","ekdm453")
customer_payment<-c("300","123","460","564","123","1245","333","1095","100","199")
df<-data.frame(customer_id,customer_payment)

df 中还有许多其他列（如名称、预算、...），这些只是我想要放置过滤器的基础。

我想将 customer_payment 的平均值存储在一个新列中，比如 avg_payments，这样我就有了唯一的交易 ID 和与它们对应的付款的平均值。

例如：aks123 出现两次，所以我希望它只出现一次，但它的 customer_payment 应该是这两个值的平均值。For Loop 不是一个选项，因为数据非常繁重。

标签： r