Calculate Transform

The calculate transform allows the user to define new fields in the dataset which are calculated from other fields using an expression syntax.

As a simple example, here we take data with a simple input sequence, and compute a some trigonometric quantities:

                    import altair as alt
import pandas as pd

data = pd.DataFrame({'t': range(101)})

alt.Chart(data).mark_line().encode(
    x='x:Q',
    y='y:Q',
    order='t:Q'
).transform_calculate(
    x='cos(datum.t * PI / 50)',
    y='sin(datum.t * PI / 25)'
)

                  

Each argument within transform_calculate is a Vega expression string, which is a well-defined set of javascript-style operations that can be used to calculate a new field from an existing one.

To streamline building these vega expressions in Python, Altair provides the altair.expr module which provides constants and functions to allow these expressions to be constructed with Python syntax; for example:

                    from altair import expr, datum

alt.Chart(data).mark_line().encode(
    x='x:Q',
    y='y:Q',
    order='t:Q'
).transform_calculate(
    x=expr.cos(datum.t * expr.PI / 50),
    y=expr.sin(datum.t * expr.PI / 25)
)

                  

Altair expressions are designed to output valid Vega expressions. The benefit of using them is that proper syntax is ensured by the Python interpreter, and tab completion of the expr submodule can be used to explore the available functions and constants.

These expressions can also be used when constructing a Filter Transform, as we shall see next.

Transform Options

The transform_calculate() method is built on the CalculateTransform class, which has the following options:

Property	Type	Description
as	`FieldName`	The field for storing the computed formula value.
calculate	`string`	A expression string. Use the variable `datum` to refer to the current data object.