r - How to give every year a number for unique players -
this question has answer here:
is there option give every year number unique player in r? example:
playerid yearid stint teamid lgid pos g po e dp score <chr> <chr> <chr> <fctr> <fctr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> 1 aardsda01 2004 1 sfn nl p 11 0 0 0 0 0.0 2 aardsda01 2006 1 chn nl p 45 1 5 0 1 7.5 3 aardsda01 2007 1 cha al p 25 2 4 1 0 3.5 4 aardsda01 2008 1 bos al p 47 3 6 0 0 9.0 5 aardsda01 2009 1 sea al p 73 2 5 0 1 7.5 6 aardsda01 2010 1 sea al p 53 2 3 1 0 2.0 7 aardsda01 2012 1 nya al p 1 0 0 0 0 0.0 8 aardsda01 2013 1 nyn nl p 43 1 5 0 0 7.5 9 aardsda01 2015 1 atl nl p 33 0 1 1 0 -1.0 10 aaronha01 1954 1 ml1 nl lf 105 205 4 6 0 -9.0 playerid yearid stint teamid lgid pos g po e dp score value <chr> <chr> <chr> <fctr> <fctr> <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <chr> 1 aardsda01 2004 1 sfn nl p 11 0 0 0 0 0.0 1 2 aardsda01 2006 1 chn nl p 45 1 5 0 1 7.5 2 3 aardsda01 2007 1 cha al p 25 2 4 1 0 3.5 3 4 aardsda01 2008 1 bos al p 47 3 6 0 0 9.0 4 5 aardsda01 2009 1 sea al p 73 2 5 0 1 7.5 5 6 aardsda01 2010 1 sea al p 53 2 3 1 0 2.0 6 7 aardsda01 2012 1 nya al p 1 0 0 0 0 0.0 7 8 aardsda01 2013 1 nyn nl p 43 1 5 0 0 7.5 8 9 aardsda01 2015 1 atl nl p 33 0 1 1 0 -1.0 9 10 aaronha01 1954 1 ml1 nl lf 105 205 4 6 0 -9.0 1
the value
column want. there option in r this???
thanks,
niek
using dplyr
can:
df %>% group_by(playerid) %>% mutate(value=1:n()) %>% ungroup
this little pipe :
- groups
data.frame
(let's it's nameddf
) based onplayerid
- then creates additional column (here named
value
can change this) filled integers (a needed rows in every group) - ungroups
data.frame
once done.
is you're looking for?
Comments
Post a Comment