Skip to content

aggregation

SumOperator

Bases: UnaryPQLOperator

Sum operator that computes sum of column.

Applies SUM operator to column.

query_string property

query_string: str

Returns query string.

AvgOperator

Bases: UnaryPQLOperator

Mean operator that computes mean of column.

Applies AVG operator to column.

query_string property

query_string: str

Returns query string.

ProductOperator

Bases: UnaryPQLOperator

Product operator that computes product of column.

Applies PRODUCT operator to column.

query_string property

query_string: str

Returns query string.

MedianOperator

Bases: UnaryPQLOperator

Median operator that computes median of column.

Applies MEDIAN operator to column.

query_string property

query_string: str

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.

query_string property

query_string: str

Returns query string.

ModeOperator

Bases: UnaryPQLOperator

Mode operator that computes mode of column.

Applies MODE operator to column.

query_string property

query_string: str

Returns query string.

MaxOperator

Bases: UnaryPQLOperator

Max operator that computes max of column.

Applies MAX operator to column.

query_string property

query_string: str

Returns query string.

MinOperator

Bases: UnaryPQLOperator

Min operator that computes min of column.

Applies MIN operator to column.

query_string property

query_string: str

Returns query string.

CountOperator

Bases: UnaryPQLOperator

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

Applies COUNT operator to column.

query_string property

query_string: str

Returns query string.

CountNullOperator

Bases: UnaryPQLOperator

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

query_string property

query_string: str

Returns query string.

CountDistinctOperator

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: str

Returns query string.

CountDistinctNullOperator

Bases: UnaryPQLOperator

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

query_string property

query_string: str

Returns query string.

IsUniqueOperator

Bases: UnaryPQLOperator

Operator that computes whether column only contains unique rows.

query_string property

query_string: str

Returns query string.

VarianceOperator

Bases: UnaryPQLOperator

Variance operator that computes variance of column.

Applies VAR operator to column.

query_string property

query_string: str

Returns query string.

StandardDeviationOperator

Bases: UnaryPQLOperator

Standard deviation operator that computes standard deviation of column.

Applies STDEV operator to column.

query_string property

query_string: str

Returns query string.