r - How to give every year a number for unique players -


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 :

  1. groups data.frame (let's it's named df) based on playerid
  2. then creates additional column (here named value can change this) filled integers (a needed rows in every group)
  3. ungroups data.frame once done.

is you're looking for?


Comments

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -