r - 创建两个分类变量和数值变量的数据透视表

Question

我有以下假设的数据框

Region <- c("District A", "District B","District A","District A","District B")
Gender <- c("Male","Male","Female", "Male","Female")
Age <- c(20, 21, 23, 34, 22)
AmountSold <- c(50, 10, 20, 4, 12)
RegionSales <- data.frame(Region, Gender, Age, AmountSold)

我想创建一个数据透视表或一个表格来显示每个性别和地区的销售量平均值以及每个性别和地区的年龄平均值。我如何在 R 中做到这一点？

Answer 1

使用dplyr，另一种选择是在across中指定变量

library(dplyr)
RegionSales %>%
    group_by(Region, Gender) %>%
    summarise(across(c(Age, AmountSold),
             ~ mean(., na.rm = TRUE), .names = "mean_{.col}"))