rowsBetween
rowsBetween.Rd
Defines the frame boundaries, from start
(inclusive) to end
(inclusive).
Usage
rowsBetween(x, start, end)
# S4 method for WindowSpec,numeric,numeric
rowsBetween(x, start, end)
Arguments
- x
a WindowSpec
- start
boundary start, inclusive. The frame is unbounded if this is the minimum long value.
- end
boundary end, inclusive. The frame is unbounded if this is the maximum long value.
Details
Both start
and end
are relative positions from the current row. For example,
"0" means "current row", while "-1" means the row before the current row, and "5" means the
fifth row after the current row.
We recommend users use Window.unboundedPreceding
, Window.unboundedFollowing
,
and Window.currentRow
to specify special boundary values, rather than using long values
directly.
A row based boundary is based on the position of the row within the partition. An offset indicates the number of rows above or below the current row, the frame for the current row starts or ends. For instance, given a row based sliding frame with a lower bound offset of -1 and a upper bound offset of +2. The frame for row with index 5 would range from index 4 to index 6.
See also
Other windowspec_method:
orderBy()
,
partitionBy()
,
rangeBetween()
Examples
if (FALSE) {
id <- c(rep(1, 3), rep(2, 3), 3)
desc <- c('New', 'New', 'Good', 'New', 'Good', 'Good', 'New')
df <- data.frame(id, desc)
df <- createDataFrame(df)
w1 <- orderBy(windowPartitionBy('desc'), df$id)
w2 <- rowsBetween(w1, 0, 3)
df1 <- withColumn(df, "sum", over(sum(df$id), w2))
head(df1)
}