Override window order and frame
These allow you to override the PARTITION BY and ORDER BY clauses
of window functions generated by grouped mutates.
window_order(.data, ...) window_frame(.data, from = -Inf, to = Inf)
.data |
A lazy data frame backed by a database query. |
... |
Variables to order by |
from, to |
Bounds of the frame. |
library(dplyr, warn.conflicts = FALSE) db <- memdb_frame(g = rep(1:2, each = 5), y = runif(10), z = 1:10) db %>% window_order(y) %>% mutate(z = cumsum(y)) %>% show_query() db %>% group_by(g) %>% window_frame(-3, 0) %>% window_order(z) %>% mutate(z = sum(x)) %>% show_query()
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.