aggregations

This module contains all possible aggregations to be used with Multirel, FastProp, Mapping.

Refer to the feature learning section in the user guide for details about how these aggregations are used in the context of feature learning.

Functions

namedtuple(typename, field_names, *[, …])

Returns a new subclass of tuple with named fields.

Attributes

Avg	Average value of a given numerical column.
Count	Number of rows in a given column.
CountAboveMean	Counts the number of values strictly greater than the mean.
CountBelowMean	Counts the number of values strictly smaller than the mean.
CountDistinct	Count function with distinct clause.
CountDistinctOverCount	COUNT DISTINCT divided by COUNT.
CountMinusCountDistinct	Counts minus counts distinct.
EWMA_1s	Exponentially weighted moving average with an half-life of 1 second.
EWMA_1m	Exponentially weighted moving average with an half-life of 1 minute.
EWMA_1h	Exponentially weighted moving average with an half-life of 1 hour.
EWMA_1d	Exponentially weighted moving average with an half-life of 1 day.
EWMA_7d	Exponentially weighted moving average with an half-life of 7 days.
EWMA_30d	Exponentially weighted moving average with an half-life of 30 days.
EWMA_90d	Exponentially weighted moving average with an half-life of 90 days.
EWMA_365d	Exponentially weighted moving average with an half-life of 365 days.
First	First value of a given column, when ordered by the time stamp.
Kurtosis	The kurtosis of a given column.
Last	Last value of a given column, when ordered by the time stamp.
Max	Largest value of a given column.
Median	Median of a given column
Min	Smallest value of a given column.
Mode	Most frequent value of a given column.
NumMax	The number of times we observe the maximum value.
NumMin	The number of times we observe the minimum value.
Q1	The 1%-quantile.
Q5	The 5%-quantile.
Q10	The 10%-quantile.
Q25	The 25%-quantile.
Q75	The 75%-quantile.
Q90	The 90%-quantile.
Q95	The 95%-quantile.
Q99	The 99%-quantile.
Skew	Skewness of a given column.
Stddev	Standard deviation of a given column.
Sum	Total sum of a given numerical column.
TimeSinceFirstMaximum	The time difference between the first time we see the maximum value and the time stamp in the population table.
TimeSinceFirstMinimum	The time difference between the first time we see the minimum value and the time stamp in the population table.
TimeSinceLastMaximum	The time difference between the last time we see the maximum value and the time stamp in the population table.
TimeSinceLastMinimum	The time difference between the last time we see the minimum value and the time stamp in the population table.
Trend	Extracts a linear trend from a variable over time and extrapolates this trend to the current time stamp.
Var	Statistical variance of a given numerical column.
VariationCoefficient	VAR divided by MEAN.
fastprop	Set of default aggregations for FastProp and FastPropTimeseries.
mapping	Set of default aggregations for Mapping.
multirel	Set of default aggregations for Multirel.