dplyr: lead() and lag() wrong when used with group_by()

by

It seems you have to pass additional argument to lag and lead functions. When I run your function without arrange, but with order_by added, everything seems to be ok.

df %>%
group_by(name) %>%
mutate(next.score = lead(score, order_by=name),
before.score = lag(score, order_by=name))

Output:

  name score next.score before.score
1   Al   100         60           NA
2  Jen    80        100           NA
3   Al    60         80          100
4  Jen   100         60           80
5   Al    80         NA           60
6  Jen    60         NA          100

My sessionInfo():

R version 3.1.1 (2014-07-10)
Platform: x86_64-w64-mingw32/x64 (64-bit)

locale:
[1] LC_COLLATE=Polish_Poland.1250  LC_CTYPE=Polish_Poland.1250        LC_MONETARY=Polish_Poland.1250
[4] LC_NUMERIC=C                   LC_TIME=Polish_Poland.1250    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] dplyr_0.4.1

loaded via a namespace (and not attached):
[1] assertthat_0.1  DBI_0.3.1       lazyeval_0.1.10 magrittr_1.5                parallel_3.1.1  Rcpp_0.11.5    
[7] tools_3.1.1

More Related Contents:

  1. Replace values greater than zero with 1 in r
  2. How does one access the piped data.frame in dplyr::funs?
  3. Extract row corresponding to minimum value of a variable by group
  4. How to select the rows with maximum values in each group with dplyr? [duplicate]
  5. Filter multiple values on a string column in dplyr
  6. Concatenate strings by group with dplyr [duplicate]
  7. Can dplyr package be used for conditional mutating?
  8. What does %>% function mean in R?
  9. Dplyr join on by=(a = b), where a and b are variables containing strings?
  10. R cumulative sum by condition with reset
  11. Proper idiom for adding zero count rows in tidyr/dplyr
  12. Why is enquo + !! preferable to substitute + eval
  13. Add NAs to make all list elements equal length
  14. Assign intermediate output to temp variable as part of dplyr pipeline
  15. pass function arguments to both dplyr and ggplot
  16. Removing NA observations with dplyr::filter()
  17. Mutate multiple columns in a dataframe
  18. Can dplyr join on multiple columns or composite key?
  19. dplyr issues when using group_by(multiple variables)
  20. dplyr – using mutate() like rowmeans()
  21. dplyr piping data – difference between `.` and `.x`
  22. Filling missing dates in a grouped time series – a tidyverse-way?
  23. mutate_each / summarise_each in dplyr: how do I select certain columns and give new names to mutated columns?
  24. Spread with duplicate identifiers (using tidyverse and %>%) [duplicate]
  25. How to change the now deprecated dplyr::funs() which includes an ifelse argument?
  26. Apply a ggplot-function per group with dplyr and set title per group
  27. Mutate multiple variable to create multiple new variables
  28. dplyr replacing na values in a column based on multiple conditions
  29. How to find difference between values in two rows in an R dataframe using dplyr
  30. Collapse all columns by an ID column [duplicate]

Leave a Comment