这是输入数据:一个表格,列出了年龄分类(年龄分类-一个年龄或一个年龄范围)和20人的性别。
library(tidyverse)
df <- tibble(agestrat = c("5", "6", "6", "7", "7", "7", "7", "9", "11", "11", "12", "14", "17", "18", "18", "22", "24", "25-40", "41-50", "51-60"),
gender = c("male", "female", "female", "male", "male", "male", "female", "female", "male", "female", "female", "male", "female", "female", "male", "male", "female", "male", "male", "female"))这是我想要的输出:
agestrat male female
5 1
6 2
7 3 1
9 1
11 1 1
12 1
14 1
17 1
18 1 1
22 1
24 1
25-40 1
41-50 1
51-60 1一种表,它聚集在各个年龄组中,并给出每个年龄组中男性和女性的数量。我在dplyr中尝试过各种方法,包括group_by、summarise和nest,但我很难理解如何创建male和female的两个新列,并在每个单元格中插入所需的计数。
谢谢!
发布于 2019-03-14 04:13:30
我们可以用count获取频率,然后将其转换为“wide”格式
library(tidyverse)
df %>%
count(agestrat, gender) %>%
spread(gender, n, fill = 0)https://stackoverflow.com/questions/55154842
复制相似问题