SEARCH AND REPLACE COLUMN NAMES¶
Performs a search-and-replace operation on all column names in a dataset, substituting every occurrence of a given search string with a replacement string. Use this worker to rename columns in bulk — for example, stripping prefixes, fixing typos, or standardising naming conventions before downstream processing.
When to use¶
Classification: process.
Tagged: bulk_rename, column_names, column_rename, dataset_transform, search_replace.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset | dataset | — | Input dataset whose column names will be modified; pass any tabular dataset object whose headers need renaming. | |
| Search | search | scalar | — | The substring to search for within each column name (case-sensitive, plain text); leave empty to match nothing. | |
| Replace | replace | scalar | — | The replacement substring that will overwrite every match found by the search string; leave empty to effectively delete the matched substring from column names. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Replaced Dataset | dataset_replace_column_names | dataset | A copy of the input dataset with all column names updated — every occurrence of the search string replaced by the replacement string; data values are unchanged. |
Disciplines¶
- 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_replace_column_names
Auto-generated from transformation schema. Worker id: dataset_replace_column_names. Schema hash: ea29cfd7ae82. Hand-curated docs in workerexamples/ override this page when present.