r - Identifying the index number in a group of counts -
i have df need tally , group group. want identify index(?) of observation in grouping.
the group a
has 4
observations, want to attach index of 3
3rd a
observation.
df %>% group_by(group) %>% mutate(count = n()) # group index count #1 1 4 #2 2 4 #3 3 4 #4 4 4 #5 b 1 1 #6 b 2 1 #7 c 1 3 #8 c 2 3 #9 c 3 3 #10 d 1 1
you want use window function row_number()
:
df %>% group_by(group) %>% mutate(index = row_number()) # explicit row_number(group)
Comments
Post a Comment