You are viewing documentation about an older version (1.18.0). View latest version

Window¶

Classes

Contains functions to form WindowSpec.

Methods

`Window.orderBy`(*cols)	Returns a `WindowSpec` object with order by clause.
`Window.order_by`(*cols)	Returns a `WindowSpec` object with order by clause.
`Window.partitionBy`(*cols)	Returns a `WindowSpec` object with partition by clause.
`Window.partition_by`(*cols)	Returns a `WindowSpec` object with partition by clause.
`Window.rangeBetween`(start, end)	Returns a `WindowSpec` object with the range frame clause.
`Window.range_between`(start, end)	Returns a `WindowSpec` object with the range frame clause.
`Window.rowsBetween`(start, end)	Returns a `WindowSpec` object with the row frame clause.
`Window.rows_between`(start, end)	Returns a `WindowSpec` object with the row frame clause.
`WindowSpec.orderBy`(*cols)	Returns a new `WindowSpec` object with the new order by clause.
`WindowSpec.order_by`(*cols)	Returns a new `WindowSpec` object with the new order by clause.
`WindowSpec.partitionBy`(*cols)	Returns a new `WindowSpec` object with the new partition by clause.
`WindowSpec.partition_by`(*cols)	Returns a new `WindowSpec` object with the new partition by clause.
`WindowSpec.rangeBetween`(start, end)	Returns a new `WindowSpec` object with the new range frame clause.
`WindowSpec.range_between`(start, end)	Returns a new `WindowSpec` object with the new range frame clause.
`WindowSpec.rowsBetween`(start, end)	Returns a new `WindowSpec` object with the new row frame clause.
`WindowSpec.rows_between`(start, end)	Returns a new `WindowSpec` object with the new row frame clause.

Attributes

`Window.CURRENT_ROW`	Returns a value representing current row.
`Window.UNBOUNDED_FOLLOWING`	Returns a value representing unbounded following.
`Window.UNBOUNDED_PRECEDING`	Returns a value representing unbounded preceding.
`Window.currentRow`
`Window.unboundedFollowing`
`Window.unboundedPreceding`