group_by_aggregation

GroupByAggregationMethods

GroupByAggregationMethods(data_frame, group_by_columns)

Class that provides group by aggregation methods to dataframe.

Parameters:

• data_frame (DataFrame) –

  DataFrame to be used.

• group_by_columns (List[str]) –

  The table to which the aggregation result should be pulled.

mean

mean()

Applies AVG operator to given dataframe.

Applies AVG operator to column.

Returns:

• DataFrame –

  DataFrame after applying AVG operator.

sum

sum()

Applies SUM operator to given dataframe.

Applies SUM operator to column.

Returns:

• DataFrame –

  DataFrame after applying SUM operator.

product

product()

Applies PRODUCT operator to given series.

Applies PRODUCT operator to column.

Returns:

• DataFrame –

  DataFrame after applying PRODUCT operator.

count

count()

Applies COUNT operator to given dataframe.

Applies COUNT operator to column.

Returns:

• DataFrame –

  DataFrame after applying COUNT operator.

count_distinct

count_distinct()

Applies PU_COUNT_DISTINCT operator to given dataframe.

Applies PU_COUNT_DISTINCT operator to column.

Returns:

• DataFrame –

  DataFrame after applying PU_COUNT_DISTINCT operator.

min

min()

Applies MIN operator to given dataframe.

Applies MIN operator to column.

Returns:

• DataFrame –

  DataFrame after applying MIN operator.

max

max()

Applies MAX operator to given dataframe.

Applies MAX operator to column.

Returns:

• DataFrame –

  DataFrame after applying MAX operator.

median

median()

Applies MEDIAN operator to given dataframe.

Applies MEDIAN operator to column.

Returns:

• DataFrame –

  DataFrame after applying MEDIAN operator.

mode

mode()

Applies MODE operator to given dataframe.

Applies MODE operator to column.

Returns:

• DataFrame –

  DataFrame after applying MODE operator.

std

std()

Applies STDEV operator to given dataframe.

Applies STDEV operator to column.

Returns:

• DataFrame –

  DataFrame after applying STDEV operator.

quantile

quantile(quantile)

Applies QUANTILE operator to given dataframe.

Applies QUANTILE operator to column.

Returns:

• DataFrame –

  DataFrame after applying QUANTILE operator.

var

var()

Applies VAR operator to given dataframe.

Applies VAR operator to column.

Returns:

• DataFrame –

  DataFrame after applying VAR operator.