range_window(preceding=None, following=None, group_by=None, order_by=None)¶
Create a range-based window clause for use with window functions.
This RANGE window clause aggregates rows based upon differences in the value of the order-by expression.
All window frames / ranges are inclusive.
preceding (int, tuple, or None, default None) – Specify None for unbounded, 0 to include current row tuple for off-center window
following (int, tuple, or None, default None) – Specify None for unbounded, 0 to include current row tuple for off-center window
group_by (expressions, default None) – Either specify here or with TableExpr.group_by
order_by (expressions, default None) – For analytic functions requiring an ordering, specify here, or let Ibis determine the default ordering (for functions like rank)
- Return type