Skip to content

aggregation

SumOperator

SumOperator(operand, **_)

Bases: UnaryPQLOperator

Sum operator that computes sum of column.

Applies SUM operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

AvgOperator

AvgOperator(operand, **_)

Bases: UnaryPQLOperator

Mean operator that computes mean of column.

Applies AVG operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

ProductOperator

ProductOperator(operand, **_)

Bases: UnaryPQLOperator

Product operator that computes product of column.

Applies PRODUCT operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

MedianOperator

MedianOperator(operand, **_)

Bases: UnaryPQLOperator

Median operator that computes median of column.

Applies MEDIAN operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

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.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

ModeOperator

ModeOperator(operand, **_)

Bases: UnaryPQLOperator

Mode operator that computes mode of column.

Applies MODE operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

MaxOperator

MaxOperator(operand, **_)

Bases: UnaryPQLOperator

Max operator that computes max of column.

Applies MAX operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

MinOperator

MinOperator(operand, **_)

Bases: UnaryPQLOperator

Min operator that computes min of column.

Applies MIN operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

CountOperator

CountOperator(operand, **_)

Bases: UnaryPQLOperator

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

Applies COUNT operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

CountNullOperator

CountNullOperator(operand, **_)

Bases: UnaryPQLOperator

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

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

CountDistinctOperator

CountDistinctOperator(operand, **_)

Bases: UnaryPQLOperator

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

Applies COUNT DISTINCT operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

CountDistinctNullOperator

CountDistinctNullOperator(operand, **_)

Bases: UnaryPQLOperator

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

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

IsUniqueOperator

IsUniqueOperator(operand, **_)

Bases: UnaryPQLOperator

Operator that computes whether column only contains unique rows.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

VarianceOperator

VarianceOperator(operand, **_)

Bases: UnaryPQLOperator

Variance operator that computes variance of column.

Applies VAR operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False

StandardDeviationOperator

StandardDeviationOperator(operand, **_)

Bases: UnaryPQLOperator

Standard deviation operator that computes standard deviation of column.

Applies STDEV operator to column.

query_string property

query_string

Returns query string.

is_boolean class-attribute instance-attribute

is_boolean = False