Function lag

  • lag(column: string | Column, offset: number): Column

    Window function: returns the value that is offset rows before the current row.

    Parameters

    • column: string | Column

      The column name or Column to compute lag for

    • offset: number

      The number of rows to look back

    Returns Column

    A Column representing the lag value

    Example

    df.select(lag(col("value"), 1))
  • lag(column: string | Column, offset: number, defaultValue: any): Column

    Window function: returns the value that is offset rows before the current row, with default value.

    Parameters

    • column: string | Column

      The column name or Column to compute lag for

    • offset: number

      The number of rows to look back

    • defaultValue: any

      Default value when the offset is beyond the window

    Returns Column

    A Column representing the lag value

  • lag(
        column: string | Column,
        offset: number,
        defaultValue: any,
        ignoreNulls: boolean,
    ): Column

    Window function: returns the value that is offset rows before the current row, with default value and null handling.

    Parameters

    • column: string | Column

      The column name or Column to compute lag for

    • offset: number

      The number of rows to look back

    • defaultValue: any

      Default value when the offset is beyond the window

    • ignoreNulls: boolean

      Whether to skip null values

    Returns Column

    A Column representing the lag value

Settings

Member Visibility