Analytic Operators

This module contains the necessary tools to perform analytic operations. It performs using the library duckdb, which is similar to pandas but has a database background.

Analytic’s main class inherits from Operators.Unary. Also, it has the following class methods:

class vtlengine.Operators.Analytic.Analytic

Analytic class

Class that inherits from Unary.

Class methods:

Validate: Validates the Dataset. analyticfunc: Specify class method that returns a dataframe using the duckdb library. Evaluate: Ensures the type of data is the correct one to perform the Analytic operators.

The method validate, validates if the structure of the Dataset is correct, the evaluate method evaluates the data within the dataframe, and the analytic function orders the measures and identifiers within the dataframe

class vtlengine.Operators.Analytic.Max

Max operator

class vtlengine.Operators.Analytic.Min

Min operator

class vtlengine.Operators.Analytic.Sum

Sum operator

class vtlengine.Operators.Analytic.Count

Count operator

class vtlengine.Operators.Analytic.Avg

Average operator

class vtlengine.Operators.Analytic.Median

Median operator

class vtlengine.Operators.Analytic.PopulationStandardDeviation

Population deviation operator

class vtlengine.Operators.Analytic.SampleStandardDeviation

Sample standard deviation operator.

class vtlengine.Operators.Analytic.PopulationVariance

Variance operator

class vtlengine.Operators.Analytic.SampleVariance

Sample variance operator

class vtlengine.Operators.Analytic.FirstValue

First value operator

class vtlengine.Operators.Analytic.LastValue

Last value operator

class vtlengine.Operators.Analytic.Lag

Lag operator

class vtlengine.Operators.Analytic.Lead

Lead operator

class vtlengine.Operators.Analytic.Rank

Rank operator

class vtlengine.Operators.Analytic.RatioToReport

Ratio operator