---
title: "advanced Transform"
slug: "advanced-transform"
updated: 2026-03-25T13:59:44Z
published: 2026-03-25T13:59:44Z
canonical: "docs.sightmachine.com/advanced-transform"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sightmachine.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Advanced Transform

The advanced transform calls arbitrary pandas methods on the input DataFrame. The result is the DataFrame produced by the final method call.

**Example:**

If we want to drop all rows that are blank and convert a mass from metric to imperial units, our configuration will look something like this:

```actionscript
{
    "transform_name": "Arbitrary Transform",
    "transform_type": "advanced",
    "filter_stream": ["*"],
    "actions": [
        {"dropna": {"axis": 0, "how": "all"}},
        {"eval": {"expr": "slugs = kilograms / 14.59"}},
        {"drop": {"labels": ["kilograms"], "axis": 1}}
    ]
}
```

**Configuration:**

**Required** and *optional* properties that can be configured for an advanced transform.

- **actions**: A list of Pandas functions to apply to the data
- **transform_name**: Unique name for the transform.
- **transform_type**: Type of transform to apply. Should be advanced.
- **filter_stream**: List of data streams to transform. Each stream can either be * (all) or asset:stream.

**Notes:**

- This transform may not be backwards-compatible across different versions of FactoryTX. New versions of Pandas may rename methods and parameters, breaking the existing configuration.
- If necessary the original DataFrame can be accessed by ‘eval’ actions such as @input_frame. Similarly, the latest DataFrame can be accessed as @frame.