Convert wrangles, with recipe examples, parameters, and behavior.
Convert Case
Change the letter case of text values.
Use convert.case to normalize capitalization while keeping the source column
or writing the result to a new column.
Behavior
- Supported modes are
lower, upper, title, and sentence.
- Omitting
output overwrites the input column.
- Input and output lists must have equal lengths.
- Non-string values are passed through unchanged and produce a warning.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|
| I/O | | | | |
input | Name, index, or list of input columns. | string, integer, array | — | Yes |
output | Name or list of output columns. If omitted, each input column is overwritten. | string, array | null | No |
| Options | | | | |
case | Letter case to apply. Sentence case lowercases the value and capitalizes sentence starts. | string; one of: | "lower" | No |
| Conditions | | | | |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
Examples
wrangles:
- convert.case:
input: product
output: product_upper
case: upper
| product_upper |
|---|
| CORDLESS DRILL |
| BEARING SEAL |
Access
| Requirement | Value |
|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|
| Catalog ID | 5 |
| Catalog key | convert.case |
| Recipe key | convert.case |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | convert |
| Documentation group | convert |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.convert.case |
| Legacy UUID | 12ff4120-3613-4801-8653-99c793477fbc |
Sources
Convert Data Type
Convert values to strings, numbers, booleans, or datetimes.
Use convert.data_type when a recipe needs consistent Python-compatible
values rather than display-only formatting.
Behavior
- Supported target types are
str, float, int, bool, and datetime.
- Omitting
data_type uses the runtime default str.
- Omitting
output overwrites the input column.
- Failed conversions retain the original value unless
default is supplied.
- Additional undocumented keyword arguments are implementation details and are
not part of the public Registry contract.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|
| I/O | | | | |
input | Name, index, or list of input columns. | string, integer, array | — | Yes |
output | Name or list of output columns. If omitted, each input column is overwritten. | string, array | null | No |
| Options | | | | |
data_type | Data type to produce. | string; one of: | "str" | No |
| Conditions | | | | |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
| Errors | | | | |
default | Value returned when conversion fails. If omitted, the original value is retained. | string, number, array, object, boolean, null | null | No |
Examples
wrangles:
- convert.data_type:
input: quantity
output: quantity_integer
data_type: int
default: 0
Access
| Requirement | Value |
|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|
| Catalog ID | 6 |
| Catalog key | convert.data_type |
| Recipe key | convert.data_type |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | convert |
| Documentation group | convert |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.convert.data_type |
| Legacy UUID | 52384f01-7164-404f-8615-063e7677a588 |
Sources
Fraction to Decimal
Convert fractions to decimals.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|
| I/O | | | | |
input | Name of the input column. | string, integer, array | — | Yes |
output | Name of the output colum. | string, array, null | null | No |
| Formatting | | | | |
decimals | Number of decimals to round fraction. | integer | 4 | No |
| Conditions | | | | |
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- convert.fraction_to_decimal:
input: fractions
output: decimals
decimals: 3
Access
| Requirement | Value |
|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|
| Catalog ID | 7 |
| Catalog key | convert.fraction_to_decimal |
| Recipe key | convert.fraction_to_decimal |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | convert |
| Documentation group | convert |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.convert.fraction_to_decimal |
| Legacy UUID | 7c55752e-70ab-4809-8298-c59436127457 |
Sources
Convert From JSON
Parse JSON text into lists, objects, scalars, booleans, or null values.
Use convert.from_json when a column contains JSON text that later wrangles
need to treat as structured values.
Behavior
- Each non-fallback value is parsed with Python's JSON parser.
- Omitting
output overwrites the input column.
- Multiple input columns may share one fallback or use one fallback per input.
- Invalid JSON raises an error unless a non-null fallback is supplied.
- Permissive Python-literal or YAML-like parsing is outside this wrangle's
contract.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|
| I/O | | | | |
input | Name, index, or list of columns containing valid JSON text. | string, integer, array | — | Yes |
output | Name or list of output columns. If omitted, each input column is overwritten. | string, array | null | No |
| Conditions | | | | |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
| Errors | | | | |
default | Value returned for empty or invalid JSON. A list may supply one fallback per input column. | string, number, array, object, boolean, null | null | No |
Examples
wrangles:
- convert.from_json:
input: attributes_json
output: attributes
| attributes |
|---|
| {"material":"steel","voltage":18} |
| ["corded","variable speed"] |
Access
| Requirement | Value |
|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|
| Catalog ID | 8 |
| Catalog key | convert.from_json |
| Recipe key | convert.from_json |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | convert |
| Documentation group | convert |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.convert.from_json |
| Legacy UUID | e370dfcf-b0fe-4c48-8a52-6f34c47e7978 |
Sources
From YAML
Convert a YAML representation into an object.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|
| I/O | | | | |
input | Name of the input column. | string, integer, array | — | Yes |
output | Name of the output column. If omitted, the input column will be overwritten. | string, array, null | null | No |
| Conditions | | | | |
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
| Errors | | | | |
default | Value to return if the row is empty or fails to be parsed as YAML. If input is a list, default may also be a list - either a single value to apply to all columns, or one value per input column. | string, array, object, number, boolean, null | null | No |
Examples
wrangles:
- convert.from_yaml:
input: column 1
{
'Product Specs': {
'length': '6 inch',
'voltage': '24V',
'weight': '3lb'
}
}
Access
| Requirement | Value |
|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|
| Catalog ID | 9 |
| Catalog key | convert.from_yaml |
| Recipe key | convert.from_yaml |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | convert |
| Documentation group | convert |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.convert.from_yaml |
| Legacy UUID | b1c20004-5f80-41c2-84d2-2d4601a033b5 |
Sources
To JSON
Convert an object to a JSON representation.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|
| I/O | | | | |
input | Name of the input column. | string, integer, array | — | Yes |
output | Name of the output column. If omitted, the input column will be overwritten. | string, array, null | null | No |
| Formatting | | | | |
ensure_ascii | If true, non-ASCII characters will be escaped. Default is false. | boolean | false | No |
indent | If indent is a non-negative integer or string, then JSON array elements and object members will be pretty-printed with that indent level. An indent level of 0, negative, or "" will only insert newlines. None (the default) selects the most compact representation. Using a positive integer indent indents that many spaces per level. If indent is a string (such as '\t'), that string is used to indent each level. | string, integer | — | No |
sort_keys | If sort_keys is true (defaults to False), then the output of dictionaries will be sorted by key. | boolean | — | No |
| Conditions | | | | |
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- convert.to_json:
input: column
output: new column
| new column |
|---|
["a","python","list"] |
{"python":"dict"} |
Access
| Requirement | Value |
|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|
| Catalog ID | 10 |
| Catalog key | convert.to_json |
| Recipe key | convert.to_json |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | convert |
| Documentation group | convert |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.convert.to_json |
| Legacy UUID | 94e54eb7-2b8c-4047-89d0-fb5d16baf396 |
Sources
To YAML
Convert an object to a YAML representation.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|
| I/O | | | | |
input | Name of the input column. | string, integer, array | — | Yes |
output | Name of the output column. If omitted, the input column will be overwritten. | string, array, null | null | No |
| Formatting | | | | |
sort_keys | If sort_keys is true (default: False), then the output of dictionaries will be sorted by key. | boolean | false | No |
allow_unicode | Allow Unicode value accepted by the runtime. | boolean | true | No |
indent | Specify the number of spaces for indentation to specify nested elements. | integer | — | No |
| Conditions | | | | |
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
Examples
wrangles:
- convert.to_yaml:
input: column 1
indent: 2
Product Specs:
length: 6 inch
voltage: 24V
weight: 3lb
Access
| Requirement | Value |
|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|
| Catalog ID | 11 |
| Catalog key | convert.to_yaml |
| Recipe key | convert.to_yaml |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | convert |
| Documentation group | convert |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.convert.to_yaml |
| Legacy UUID | 4cd6252f-ce47-4a9d-8272-3d87e875b72a |
Sources