Format Wrangles

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

Clean Whitespaces |clean_whitespaces

Condense multiple spaces to a single space and convert special space characters to a standard space.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name or list of input columns.	string, integer, array	—	Yes
output	Name or list of output columns.	string, array, null	null	No
Options
trim	Whether to trim leading and trailing spaces. Default True.	boolean	true	No
remove_literals	Whether to remove special space characters such as new lines etc. Default True.	boolean	true	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:
  - clean_whitespaces:
      input: Products

Products
Hello world!
Hello universe!

Products
Hello world!
Hello universe!

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	72
Catalog key	clean_whitespaces
Recipe key	clean_whitespaces
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.main.clean_whitespaces
Legacy UUID	e36e15c4-f0ad-43f8-8555-ef683a8ab892

Sources

• WranglesPY clean_whitespaces implementation
• Archived clean_whitespaces Markdown

---

Dates |format.dates

Format a date.

Format a date into the desired pattern.

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.	string, array, null	null	No
Formatting
format	String pattern to format date.	string	—	Yes
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:
  - format.dates:
      input: Date
      output: Output Format
      format: '%Y-%m-%d'  # must be wrapped by quotes " or '

Date
6/23/1912

Output Format
1912-06-23

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	31
Catalog key	format.dates
Recipe key	format.dates
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.dates
Legacy UUID	a3c15135-4f7a-4659-83fd-f657afa603c9

Sources

• WranglesPY format.dates implementation
• Archived format.dates Markdown

---

Pad |format.pad

Pad a string to a fixed length.

Pad a string to a fixed length

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.	string, array, null	null	No
Options
side	Side from which to fill resulting string.	string	—	Yes
skip_empty	If true, skip padding for empty or whitespace-only values.	boolean	false	No
Formatting
pad_length	Length for the output.	integer	—	Yes
char	The character to pad the input with.	string	—	Yes
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:
  - format.pad:
      input: Part Number
      pad_length: 5
      side: left
      char: "-"

Part Number
0458
396
84
98516

Part Number
-0458
--396
---84
98516

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	32
Catalog key	format.pad
Recipe key	format.pad
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.pad
Legacy UUID	76c19378-38f4-45aa-85d1-3cdf8f8aae29

Sources

• WranglesPY format.pad implementation
• Archived format.pad Markdown

---

Prefix |format.prefix

Add a prefix to a column.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the input column.	string, integer, array	—	Yes
output	(Optional) Name of the output column.	string, array, null	null	No
Options
value	Prefix value to add.	string, integer, number	—	Yes
skip_empty	Whether to skip empty values.	boolean	false	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:
  - format.prefix:
      input: Data
      output: Prefix
      value: anti

Data
freeze
dote
hero

Prefix
antifreeze
antidote
antihero

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	33
Catalog key	format.prefix
Recipe key	format.prefix
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.prefix
Legacy UUID	c12f99b9-2363-4da7-8405-7c73b87906e5

Sources

• WranglesPY format.prefix implementation
• Archived format.prefix Markdown

---

Format Price Breaks |format.price_breaks

Expand non-empty price-break cells into paired category and value columns.

Behavior

Expand non-empty price-break cells into paired category and value columns.

This guidance was derived from the callable signature.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name, index, or list of input columns.	array	—	Yes
Formatting
categoryLabel	Prefix for output columns that identify the source price-break category.	string	—	Yes
valueLabel	Prefix for output columns that contain the corresponding price-break value.	string	—	Yes
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

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	34
Catalog key	format.price_breaks
Recipe key	format.price_breaks
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	No
Recipe Writer exclusion	This newer wrangle is outside the pinned baseline.
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.price_breaks
Legacy UUID	None

Sources

• WranglesPY format.price_breaks implementation

---

Remove Duplicates |format.remove_duplicates

Remove duplicates from a list. Preserves input order.

Remove duplicate values in a list.

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.	string, array, null	null	No
Options
ignore_case	Ignore case when removing duplicates.	boolean	false	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:
    - format.remove_duplicates:
        input: Attack of the Clones
        output: Commander
        where: Rank = 'Commander'

Rank	Attack of the Clones
Commander	['Cody', 'Cody', 'Cody']
Captain	['Rex', 'Rex', 'Rex']

Commander
['Cody']

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	35
Catalog key	format.remove_duplicates
Recipe key	format.remove_duplicates
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.remove_duplicates
Legacy UUID	283b9e78-b2b2-43d0-844f-9842c33120aa

Sources

• WranglesPY format.remove_duplicates implementation
• Archived format.remove_duplicates Markdown

---

Significant Figures |format.significant_figures

Format a value to a specific number of significant figures.

Format a value to a specific number of significant figures

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.	string, array, null	null	No
Formatting
significant_figures	Number of significant figures to format to. Default is 3.	integer	3	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:
  - format.significant_figures:
      input: Data
      significant_figures: 2
      output: Data to 2 Figures

Data
1.25
12.3
55.6

Data to 2 Figures
1.2
12
55

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	36
Catalog key	format.significant_figures
Recipe key	format.significant_figures
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.significant_figures
Legacy UUID	a359f72a-5250-4dd8-84f6-8a8173bee0f6

Sources

• WranglesPY format.significant_figures implementation
• Archived format.significant_figures Markdown

---

Suffix |format.suffix

Add a suffix to a column.

Add a suffix to a column

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the input column.	string, integer, array	—	Yes
output	(Optional) Name of the output column.	string, null	null	No
Options
value	Suffix value to add.	string, integer, number, array	—	Yes
skip_empty	Whether to skip empty values.	boolean	false	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:
  - format.suffix:
      input: Data
      output: Suffix
      value: ic

Data
sto
hero
icon

Suffix
stoic
heroic
iconic

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	37
Catalog key	format.suffix
Recipe key	format.suffix
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.suffix
Legacy UUID	8d127060-ba2d-4934-897f-07662e01e40b

Sources

• WranglesPY format.suffix implementation
• Archived format.suffix Markdown

---

Trim |format.trim

Remove excess whitespace at the start and end of text.

Remove excess whitespace at the start and end of text. Can accept multiple columns.

note

Non-string values pass through unaltered.

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.	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

Examples

wrangles:
  - format.trim:
      input:
        - col1
      output: col1 trimmed

col1
Hello World

col1	col1 trimmed
Hello World	Hello World

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	38
Catalog key	format.trim
Recipe key	format.trim
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	format
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.format.trim
Legacy UUID	af16b3c1-c230-4868-8ebe-f574904a0c76

Sources

• WranglesPY format.trim implementation
• Archived format.trim Markdown

---

Remove Words |remove_words

Remove all the elements that occur in one list from another.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of column to remove words from.	string, integer, array	—	Yes
to_remove	Column or list of columns with a list of words to be removed.	string	—	Yes
output	Name of the output columns.	string, array, null	null	No
Options
tokenize_to_remove	Tokenize all to_remove inputs.	boolean	false	No
ignore_case	Ignore input and to_remove case.	boolean	true	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:
   - remove_words:
        input: Description
        to_remove: # To Remove columns must be list
          - Materials
          - Colours
        output: Product
        tokenize_to_remove: True
        ignore_case: False

Colours	Materials	Description
['Blue']	['Steel']	Steel Blue Bottle
['Blue']	['Steel']	['Steel', 'Blue', 'Bottle']

Product
Bottle
Bottle

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	88
Catalog key	remove_words
Recipe key	remove_words
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.main.remove_words
Legacy UUID	543b96c3-f354-48be-8046-bf0cb9fbaf56

Sources

• WranglesPY remove_words implementation
• Archived remove_words Markdown

---

Replace |replace

Quick find and replace for simple values. Can use regex if 'input' in params and isinstance(params['input'], list):in the find field.

Quick find and replace for simple values. Can use regex in the find field.

note

Values that are not a number or a string pass through unaltered.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name or list of input column.	string, integer, array	—	Yes
output	Name or list of output column.	string, array, null	null	No
Options
find	Pattern to find using regex.	string	—	Yes
replace	Value to replace the pattern found.	string	—	Yes
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:
  - replace:
      input: Product Data
      find: brg
      replace: bearing

Product Data
SKF ball brg
brg seal

Product Data
SKF ball bearing
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	90
Catalog key	replace
Recipe key	replace
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.main.replace
Legacy UUID	f0ab715e-9e0e-4614-83e4-5cd8ea08a09f

Sources

• WranglesPY replace implementation
• Archived replace Markdown

---

Round |round

Round column(s) to the specified decimals.

Round numbers in a column to the nearest decimal point of your choosing.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the input column(s).	string, integer, array	—	Yes
output	Name of the output column(s).	string, array, null	null	No
Formatting
decimals	Number of decimal places to round column.	integer	0	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:
  - round:
      input: Cost Per Unit
      output: Cost Rounded
      decimals: 2

Cost Per Unit
3.14159
2.71828

Cost Rounded
3.14
2.72

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	No
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	91
Catalog key	round
Recipe key	round
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.pandas.round
Legacy UUID	12f3111b-8511-4e42-8d3f-b5302dc3b4e4

Sources

• WranglesPY round implementation
• Archived round Markdown

---

Translate |translate

Translate the input to a different language. Requires WrangleWorks Account and DeepL API Key (A free account for up to 500,000 characters per month is available).

Translate the input column to another language. Powered by DeepL.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the column to translate.	string, integer, array	—	Yes
output	Name of the output column.	string, array	—	Yes
Options
target_language	Code of the language to translate to.	string; one of: Bulgarian Chinese Czech Danish Dutch English (American) English (British) Estonian Finnish French German Greek Hungarian Italian Japanese Latvian Lithuanian Polish Portuguese Portuguese (Brazilian) Romanian Russian Slovak Slovenian Spanish Swedish	—	Yes
source_language	Code of the language to translate from. If omitted, automatically detects the input language.	string; one of: Auto Bulgarian Chinese Czech Danish Dutch English Estonian Finnish French German Greek Hungarian Italian Japanese Latvian Lithuanian Polish Portuguese Romanian Russian Slovak Slovenian Spanish Swedish	"AUTO"	No
case	Allow changing the case of the input prior to translation.	string, 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:
  - translate:
      input: Español
      output: English
      source_language: Spanish
      target_language: English (British)

Español
¡Hola Mundo!

English
Hello World!

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	Yes
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	96
Catalog key	translate
Recipe key	translate
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.main.translate
Legacy UUID	73c3ceb6-ffd8-4d74-8389-c83b99d33bb0

Sources

• WranglesPY translate implementation
• Archived translate Markdown

---

Standardize (Deprecated) |standardize

Deprecated

This compatibility wrangle remains available for existing recipes. Use standardize.custom for new recipes.

Deprecated compatibility key for standardize.custom, which standardizes data using a trained DIY or bespoke model.

Run a standardize wrangle, such as one that expands abbreviations. A standardization wrangle must be trained first.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name or list of input columns.	string, integer, array	—	Yes
output	Name or list of output columns.	string, array, null	null	No
Options
case_sensitive	Allows the wrangle to be case sensitive if set to True, default is False.	boolean	false	No
Details
model_id	The ID of the wrangle to use (do not include 'find' and 'replace').	string, array	—	Yes
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:
  - standardize:
      input: Abbrev
      output: Abbreviations
      model_id: code_here

Abbrev
ASAP
ETA

Abbreviations
As Soon As Possible
Estimated Time of Arrival

Access

Requirement	Value
AI-powered	No
Requires WrangleWorks account	Yes
Requires subscription	No
Requires external API key	No

Technical details

Field	Value
Catalog ID	95
Catalog key	standardize
Recipe key	standardize
Catalog status	active
Lifecycle status	deprecated
Recipe Writer eligible	No
Recipe Writer exclusion	Deprecated compatibility key; use standardize.custom.
Replaced by	standardize.custom
Namespace	Root-level
Documentation group	format
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.main.standardize
Legacy UUID	53cd3fdd-24e2-4411-8655-6014b92a3f3a

Sources

• WranglesPY standardize implementation
• Archived standardize Markdown