verticapy.vDataColumn.var#

vDataColumn.var() → bool | float | str | timedelta | datetime#

Aggregates the vDataFrame using VAR aggregation (Variance), providing insights into the spread or variability of data for the input column. The variance is a measure of how much individual data points deviate from the mean, helping to assess data consistency and variation.

Returns#

PythonScalar: variance

Examples#

For this example, let’s generate a dataset and calculate the variance of a column:

import verticapy as vp

data = vp.vDataFrame(
    {
        "x": [1, 2, 4, 9, 10, 15, 20, 22],
        "y": [1, 2, 1, 2, 1, 1, 2, 1],
        "z": [10, 12, 2, 1, 9, 8, 1, 3],
    }
)


data["x"].sum()
Out[3]: 83.0

Note

All the calculations are pushed to the database.

Hint

For more precise control, please refer to the aggregate method.