aggregation

SumOperator

SumOperator(operand, **_)

Bases: UnaryPQLOperator

Sum operator that computes sum of column.

Applies SUM operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

AvgOperator

AvgOperator(operand, **_)

Bases: UnaryPQLOperator

Mean operator that computes mean of column.

Applies AVG operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

ProductOperator

ProductOperator(operand, **_)

Bases: UnaryPQLOperator

Product operator that computes product of column.

Applies PRODUCT operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

MedianOperator

MedianOperator(operand, **_)

Bases: UnaryPQLOperator

Median operator that computes median of column.

Applies MEDIAN operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

QuantileOperator

QuantileOperator(operand, quantile)

Bases: UnaryPQLOperator

Quantile operator that computes quantile of column.

Applies QUANTILE operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand for which quantile is computed.

• quantile (float) –

  Quantile to compute.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

ModeOperator

ModeOperator(operand, **_)

Bases: UnaryPQLOperator

Mode operator that computes mode of column.

Applies MODE operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

MaxOperator

MaxOperator(operand, **_)

Bases: UnaryPQLOperator

Max operator that computes max of column.

Applies MAX operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

MinOperator

MinOperator(operand, **_)

Bases: UnaryPQLOperator

Min operator that computes min of column.

Applies MIN operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

CountOperator

CountOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes count of values in series excluding null values.

Applies COUNT operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

CountNullOperator

CountNullOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes count of values in series including null values.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

CountDistinctOperator

CountDistinctOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes distinct count of values in series excluding null values.

Applies COUNT DISTINCT operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

CountDistinctNullOperator

CountDistinctNullOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes distinct count of values in series including null values.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

IsUniqueOperator

IsUniqueOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes whether column only contains unique rows.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

VarianceOperator

VarianceOperator(operand, **_)

Bases: UnaryPQLOperator

Variance operator that computes variance of column.

Applies VAR operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

StandardDeviationOperator

StandardDeviationOperator(operand, **_)

Bases: UnaryPQLOperator

Standard deviation operator that computes standard deviation of column.

Applies STDEV operator to column.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.