Convert Wrangles

Convert wrangles, with recipe examples, parameters, and behavior.

Convert Case |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 upper title sentence	"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
Cordless Drill
bearing seal

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

• WranglesPY convert.case implementation
• Legacy convert.case documentation

---

Convert Data Type |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 float int bool datetime	"str"	No
Errors
default	Value returned when conversion fails. If omitted, the original value is retained.	string, number, array, object, boolean, null	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

Examples

wrangles:
  - convert.data_type:
      input: quantity
      output: quantity_integer
      data_type: int
      default: 0

quantity
12
not available

quantity_integer
12
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

• WranglesPY convert.data_type implementation
• Legacy convert.data_type documentation

---

Fraction to Decimal |convert.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

fractions
3/32
25/64

decimals
0.094
0.391

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

• WranglesPY convert.fraction_to_decimal implementation
• Archived convert.fraction_to_decimal Markdown

---

Convert From JSON |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
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
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.from_json:
      input: attributes_json
      output: attributes

attributes_json
"{"material":"steel","voltage":18}"
"["corded","variable speed"]"

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

• WranglesPY convert.from_json implementation
• Legacy convert.from_json documentation

---

From YAML |convert.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
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
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.from_yaml:
      input: column 1

Product Specs:
  length: 6 inch
  voltage: 24V
  weight: 3lb

{
  '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

• WranglesPY convert.from_yaml implementation
• Archived convert.from_yaml Markdown

---

To JSON |convert.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

column
['a', 'python', 'list']
{'python': 'dict'}

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

• WranglesPY convert.to_json implementation
• Archived convert.to_json Markdown

---

To YAML |convert.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'
  }
}

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

• WranglesPY convert.to_yaml implementation
• Archived convert.to_yaml Markdown