DATASET ADD COLUMN FROM CURVE LOOKUP¶
Adds a new column to a dataset by performing a per-row lookup against a reference curve: for each row the curve is clipped to the [X-start, X-end] window defined by two existing dataset columns, and a scalar value (average, first, max, or min Y) is extracted and stored in the new column. Use this worker when you need to enrich a tabular dataset with curve-derived metrics computed over row-specific intervals.
When to use¶
Classification: process.
Tagged: add_column, clip, curve_extraction, curve_lookup, dataset, row_wise, yavg, yfirst.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset | dataset | — | Input dataset (tabular) that must contain at least the two columns referenced as X-start and X-end bounds; each row drives one curve lookup. | |
| Curve | curve | vector | — | Reference curve (X-Y vector) whose Y values are sampled after clipping to the per-row [X-start, X-end] window. | |
| New Column Name | new_col | scalar | — | Name of the new column to append to the dataset; provide a quoted string (e.g. ‘peak_force’). | |
| Column That Contains The X-Start | start_column | scalar | — | Name of the dataset column whose values define the X-axis lower bound used to clip the curve for each row; must be an existing numeric column in the input dataset. | |
| Column That Contains The Y-Start | end_column | scalar | — | Name of the dataset column whose values define the X-axis upper bound used to clip the curve for each row; must be an existing numeric column in the input dataset. | |
| Lookup Type | lookup_type | scalar | yavg | Aggregation applied to the clipped curve segment per row: ‘yavg’ (mean Y, default), ‘yfirst’ (first Y value), ‘ymax’ (maximum Y), or ‘ymin’ (minimum Y). |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Dataset with new Column | dataset | dataset | The input dataset with one additional column appended, named according to ‘new_col’, containing the per-row curve-lookup scalar result. |
Disciplines¶
- data.curve.pair
- data.curve.transform
- data.dataset.transform
Runnable example¶
A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: /api/workflow/example?id=dataset_add_column_from_curve_lookup
Auto-generated from transformation schema. Worker id: dataset_add_column_from_curve_lookup. Schema hash: e81ebae0aafe. Hand-curated docs in workerexamples/ override this page when present.