snowflake.snowpark.DataFrameAnalyticsFunctions¶

class snowflake.snowpark.DataFrameAnalyticsFunctions(df: DataFrame)[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/dataframe_analytics_functions.py#L30-L678)¶

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.