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

snowflake.snowpark.DataFrameAnalyticsFunctions¶

class snowflake.snowpark.DataFrameAnalyticsFunctions(df: DataFrame)[source]¶

Bases: object

Provides data analytics functions for DataFrames. To access an object of this class, use DataFrame.analytics.

Methods

compute_lag(cols, lags, order_by, group_by)

Creates lag columns to the specified columns of the DataFrame by grouping and ordering criteria.

compute_lead(cols, leads, order_by, group_by)

Creates lead columns to the specified columns of the DataFrame by grouping and ordering criteria.

cumulative_agg(aggs, group_by, order_by, ...)

Applies cummulative aggregations to the specified columns of the DataFrame using defined window direction, and grouping and ordering criteria.

moving_agg(aggs, window_sizes, order_by, ...)

Applies moving aggregations to the specified columns of the DataFrame using defined window sizes, and grouping and ordering criteria.

time_series_agg(time_col, aggs, windows, ...)

Applies aggregations to the specified columns of the DataFrame over specified time windows, and grouping criteria.