deephaven.agg

This module implement various aggregations that can be used in deephaven table’s aggregation operations.

class Aggregation(j_agg_spec=None, j_aggregation=None, cols=None)

Bases: object

An Aggregation object represents an aggregation operation.

Note: It should not be instantiated directly by user code but rather through the static methods on the class.

abs_sum(cols=None)

Creates an Absolute-sum aggregation.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

avg(cols=None)

Creates an Average aggregation.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

count_(col)

Creates a Count aggregation. This is not supported in ‘Table.agg_all_by’.

Parameters:

col (str) – the column to hold the counts of each distinct group

Return type:

Aggregation

Returns:

an aggregation

count_distinct(cols=None, count_nulls=False)

Creates a Count Distinct aggregation which computes the count of distinct values within an aggregation group for each of the given columns.

Parameters:

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

• count_nulls (bool) – whether null values should be counted, default is False

Return type:

Aggregation

Returns:

an aggregation

distinct(cols=None, include_nulls=False)

Creates a Distinct aggregation which computes the distinct values within an aggregation group for each of the given columns and stores them as vectors.

Parameters:

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

• include_nulls (bool) – whether nulls should be included as distinct values, default is False

Return type:

Aggregation

Returns:

an aggregation

first(cols=None)

Creates a First aggregation.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

formula(formula, formula_param, cols=None)

Creates a user defined formula aggregation. This formula can contain a combination of any of the following:

Built-in functions such as min, max, etc.

Mathematical arithmetic such as *, +, /, etc.

User-defined functions

Parameters:

• formula (str) – the user defined formula to apply to each group.

• formula_param (str) – the parameter name for the input column’s vector within the formula. If formula is max(each), then each is the formula_param.

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

group(cols=None)

Creates a Group aggregation.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

last(cols=None)

Creates Last aggregation.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

max_(cols=None)

Creates a Max aggregation to the ComboAggregation object.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

median(cols=None, average_evenly_divided=True)

Creates a Median aggregation which computes the median value within an aggregation group for each of the given columns.

Parameters:

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

• average_evenly_divided (bool) – when the group size is an even number, whether to average the two middle values for the output value. When set to True, average the two middle values. When set to False, use the smaller value. The default is True. This flag is only valid for numeric types.

Return type:

Aggregation

Returns:

an aggregation

min_(cols=None)

Creates a Min aggregation.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

partition(col, include_by_columns=True)

Creates a Partition aggregation. This is not supported in ‘Table.agg_all_by’.

Parameters:

• col (str) – the column to hold the sub tables

• include_by_columns (bool) – whether to include the group by columns in the result, default is True

Return type:

Aggregation

Returns:

an aggregation

pct(percentile, cols=None, average_evenly_divided=False)

Creates a Percentile aggregation which computes the percentile value within an aggregation group for each of the given columns.

Parameters:

• percentile (float) – the percentile used for calculation

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

• average_evenly_divided (bool) – when the percentile splits the group into two halves, whether to average the two middle values for the output value. When set to True, average the two middle values. When set to False, use the smaller value. The default is False. This flag is only valid for numeric types.

Return type:

Aggregation

Returns:

an aggregation

sorted_first(order_by, cols=None)

Creates a SortedFirst aggregation.

Parameters:

• order_by (str) – the column to sort by

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

sorted_last(order_by, cols=None)

Creates a SortedLast aggregation.

Parameters:

• order_by (str) – the column to sort by

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

std(cols=None)

Creates a Std (sample standard deviation) aggregation.

Sample standard deviation is computed using Bessel’s correction, which ensures that the sample variance will be an unbiased estimator of population variance.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

sum_(cols=None)

Creates a Sum aggregation.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

unique(cols=None, include_nulls=False, non_unique_sentinel=None)

Creates a Unique aggregation which computes the single unique value within an aggregation group for each of the given columns. If all values in a column are null, or if there is more than one distinct value in a column, the result is null or the specified non_unique_sentinel value.

Parameters:

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

• include_nulls (bool) – whether null is treated as a value for the purpose of determining if the values in the aggregation group are unique, default is False.

• non_unique_sentinel (Any) – the non-null sentinel value when no unique value exists, default is None. Must be a non-None value when include_nulls is True.

Return type:

Aggregation

Returns:

an aggregation

var(cols=None)

Creates a sample Var aggregation.

Sample standard deviation is computed using Bessel’s correction, which ensures that the sample variance will be an unbiased estimator of population variance.

Parameters:

cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

weighted_avg(wcol, cols=None)

Creates a Weighted-avg aggregation.

Parameters:

• wcol (str) – the name of the weight column

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation

weighted_sum(wcol, cols=None)

Creates a Weighted-sum aggregation.

Parameters:

• wcol (str) – the name of the weight column

• cols (Union[str, List[str]]) – the column(s) to aggregate on, can be renaming expressions, i.e. “new_col = col”; default is None, only valid when used in Table agg_all_by operation

Return type:

Aggregation

Returns:

an aggregation