Select Wrangles

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

Drop |drop

Drop (Delete) selected column(s).

Drop (Delete) selected column(s)

Parameters

Name	Description	Accepted Values	Default	Required
I/O
columns	Name of the column(s) to drop.	string, array	—	Yes
Conditions
if	Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}.	string	—	No

Examples

wrangles:
  - drop:
      columns:
        - Material

Material	Product Data
Ceramic	SKF ball brg
Rubber	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	76
Catalog key	drop
Recipe key	drop
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.pandas.drop
Legacy UUID	363bffbf-397e-4975-8382-e9efa5e9eed6

Sources

• WranglesPY drop implementation
• Archived drop Markdown

---

Filter |filter

Filter the dataframe based on the contents. If multiple filters are specified, all must be correct. For complex filters, use the where parameter.

Filter the dataframe based on the contents.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the column to filter on. If multiple are provided, all must match the criteria.	string, integer, array	[]	No
Options
equal	Select rows where the values equal a given value.	string, array, null	null	No
not_equal	Select rows where the values do not equal a given value.	string, array, null	null	No
is_in	Select rows where the values are in a given list.	string, array, null	null	No
not_in	Select rows where the values are not in a given list.	string, array, null	null	No
greater_than	Select rows where the values are greater than a specified value. Does include the value itself.	integer, number, null	null	No
greater_than_equal_to	Select rows where the values are greater than a specified value. Does include the value itself.	integer, number, null	null	No
less_than	Select rows where the values are less than a specified value. Does not include the value itself.	integer, number, null	null	No
less_than_equal_to	Select rows where the values are less than a specified value. Does include the value itself.	integer, number, null	null	No
between	Value or list of values to filter that are in between two parameter values.	array, null	null	No
contains	Select rows where the input contains the value. Allows regular expressions.	string, null	null	No
not_contains	Select rows where the input does not contain the value. Allows regular expressions.	string, null	null	No
is_null	If true, select all rows where the value is NULL. If false, where is not NULL.	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:
  # Select only red fruits
  - filter:
      input: Color
      equal:
        - red

Color	Fruit
red	Apple
green	Apple
orange	Orange
red	Strawberry

Color	Fruit
red	Apple
red	Strawberry

Access

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

Technical details

Field	Value
Catalog ID	78
Catalog key	filter
Recipe key	filter
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.main.filter
Legacy UUID	e3242acf-d204-433f-8373-205b77481131

Sources

• WranglesPY filter implementation
• Archived filter Markdown

---

Columns |select.columns

Select columns from the dataframe.

Select columns from the dataframe

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the column(s) to select.	string, integer, 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:
  - select.columns:
      input: Manufacturer

Part Number	Manufacturer
1234	SKF
5678	Timken

Manufacturer
SKF
Timken

Access

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

Technical details

Field	Value
Catalog ID	49
Catalog key	select.columns
Recipe key	select.columns
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.columns
Legacy UUID	bca12c60-3957-4dc5-83f7-5ee460df2a11

Sources

• WranglesPY select.columns implementation
• Archived select.columns Markdown

---

Dictionary Element |select.dictionary_element

Select one or more element of a dictionary.

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 replaced.	string, array, null	null	No
Options
element	The key or keys from the dictionary to select. If a single key is provided, the value will be returned If a lists of keys are selected, the result will be a new dictionary.	string	—	Yes
Errors
default	Set the default value to return if the specified element doesn't exist. If selecting multiple elements, a dict of defaults can be set.	string, number, array, object, boolean, 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:
  - select.dictionary_element:
      input: Properties
      output: Shapes
      element: shapes
      default: square
      where: Part Number = 1234

Properties	Part Number
{'colours': ['red', 'white', 'blue'], 'shapes': 'round', 'materials': 'tungsten'}	1234
{'colours': ['green', 'yellow', 'orange'], 'shapes': 'square', 'materials': 'tungsten'}	5678

Shapes
round

wrangles:
  - select.dictionary_element:
      input: Properties
      element:
        - shapes
        - materials

Properties
{'colours': ['red', 'white', 'blue'], 'shapes': 'round', 'materials': 'tungsten'}
{'colours': ['green', 'yellow', 'orange'], 'shapes': 'square', 'materials': 'tungsten'}

Properties
{'shapes': 'round', 'materials': 'tungsten'}
{'shapes': 'square', 'materials': 'tungsten'}

wrangles:
  - select.dictionary_element:
      input: Properties
      output: Output Dict
      element:
        - Col*

Column
{'Col1': 'A', 'Col2': 'B', 'Other3': 'C'}

Column	Output Dict
{'Col1': 'A', 'Col2': 'B', 'Col3': 'C'}	{'Col1': 'A', 'Col2': 'B'}

wrangles:
  - select.dictionary_element:
      input: Properties
      output: Output Dict
      element:
        - "regex: .*2"

Column
{'Col1': 'A', 'Col2': 'B', 'Col3': 'C'}

Output Dict
{'Col2': 'B'}

wrangles:
  - select.dictionary_element:
      input: Properties
      output: Output Dict
      element:
        - Col1: Column 1
        - Col2: Column 2

Column
{'Col1': 'A', 'Col2': 'B', 'Col3': 'C'}

Output Dict
{'Column 1': 'A', 'Column 2': 'B'}

wrangles:
  - select.dictionary_element:
      input: Properties
      output: Output Dict
      element:
        - Col1
        - Col3
      default:
        Col1: Z
        Col3: Y

Column
{'Col1': 'A', 'Col2': 'B', 'Col3': 'C'}
{'Col1': 'D', 'Col2': 'E'}

Output Dict
{'Col1': 'A', 'Col3': 'C'}
{'Col1': 'D', 'Col3': 'Y'}

Access

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

Technical details

Field	Value
Catalog ID	50
Catalog key	select.dictionary_element
Recipe key	select.dictionary_element
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.dictionary_element
Legacy UUID	5adaeada-6da8-464f-84cb-9fb5ecc17e48

Sources

• WranglesPY select.dictionary_element implementation
• Archived select.dictionary_element Markdown

---

Element |select.element

Select elements of lists or dicts using python syntax like col[0]['key'].

Select elements of lists or dictionaries using Python syntax like col[1:3]['key'].

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the input column and sub elements This permits by index for lists or dict and by key for dicts e.g. col[0]['key'] // [{"key":"val"}] -> "val".	string, integer, array	—	Yes
output	Name of the output column(s).	string, array, null	null	No
Errors
default	Set the default value to return if the specified element doesn't exist.	string, number, array, object, 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:
  - select.element:
      input: Column A[0]
      output: First Element

Column A
[A, 0.9]
[B, 0.8]

First Element
A
B

Access

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

Technical details

Field	Value
Catalog ID	51
Catalog key	select.element
Recipe key	select.element
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.element
Legacy UUID	223d2f4e-3247-4189-8b6c-e73fe44c4266

Sources

• WranglesPY select.element implementation
• Archived select.element Markdown

---

Group By |select.group_by

Group and aggregate the data.

Group and aggregate the data

Parameters

Name	Description	Accepted Values	Default	Required
I/O
by	List of the input columns to group on.	string, array	[]	No
Options
list	Group and return all values for these column(s) as a list.	string, array	—	No
first	The first value for these column(s).	string, array	—	No
last	The last value for these column(s).	string, array	—	No
min	The minimum value for these column(s).	string, array	—	No
max	The maximum value for these column(s).	string, array	—	No
mean	The mean (average) value for these column(s).	string, array	—	No
median	The median value for these column(s).	string, array	—	No
nunique	The count of unique values for these column(s).	string, array	—	No
count	The count of values for these column(s).	string, array	—	No
counts	Return a dictionary containing the count of each distinct value for these column(s). Keys are converted to JSON-safe strings; missing values use the key "null" and booleans use lowercase "true"/"false".	string, array	—	No
std	The standard deviation of values for these column(s).	string, array	—	No
sum	The total of values for these column(s).	string, array	—	No
any	Return true if any of the values for these column(s) are true.	string, array	—	No
all	Return true if all of the values for these column(s) are true.	string, array	—	No
p75	Get a percentile. Note, you can use any integer here for the corresponding percentile.	string, array	—	No
custom.*	Placeholder for custom functions. Replace 'placeholder' with the name of the function.	string, array	—	No
Formatting
auto_rename_columns	If true (default), aggregated column names include the operation as a suffix (e.g. Value.sum). If false, column names are left as-is; use a dictionary entry to supply a custom output name (e.g. - Value: Total).	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:
  - select.group_by:
      by:
        - Product Type
      sum: Quantity
      mean: Price ($)

Product	Quantity	Price ($)	Product Type
Hammer	3	12.99	Hand Tools
Ratchet Wrench	12	6.99	Hand Tools
Cordless Drill	2	49.99	Power Tools
Reciprocating Saw	7	29.99	Power Tools

Product Type	Quantity.sum	Price ($).mean
Hand Tools	15	9.99
Power Tools	9	39.99

wrangles:
  - select.group_by:
      by: Category
      custom.sum_times_two: Quantity

Category	Quantity
Hand Tools	3
Hand Tools	1
Hand Tools	2
Power Tools	4

Category	Quantity.sum_times_two
Hand Tools	12
Power Tools	4

Access

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

Technical details

Field	Value
Catalog ID	52
Catalog key	select.group_by
Recipe key	select.group_by
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.group_by
Legacy UUID	c0af10b1-423a-416c-8cb5-7e7fe1164964

Sources

• WranglesPY select.group_by implementation
• Archived select.group_by Markdown

---

Head |select.head

Return the first n rows.

Return the first n rows

Parameters

Name	Description	Accepted Values	Default	Required
Options
n	Number of rows to return.	integer	—	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:
  - select.head:
      n: 2

Product	Manufacturer
Ball Bearing	SKF
Bearing Race	Timken
Needle Bearing	Acme Bearings
Roller Bearing	General Bearing Co.

Product	Manufacturer
Ball Bearing	SKF
Bearing Race	Timken

Access

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

Technical details

Field	Value
Catalog ID	53
Catalog key	select.head
Recipe key	select.head
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.head
Legacy UUID	237af1ec-db7d-415a-88b7-70586a2191fb

Sources

• WranglesPY select.head implementation
• Archived select.head Markdown

---

Highest Confidence |select.highest_confidence

Select the option with the highest confidence from multiple columns. Inputs are expected to be of the form [<<value>>, <<confidence_score>>].

Select the option with the highest confidence from multiple columns. Inputs are expected to be of the form [value, confidence_score].

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	List of the input columns to select from.	array	—	Yes
output	If two columns; the result and confidence. If one column; [result, confidence].	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:
  - select.highest_confidence:
      input:
        - Col1
        - Col2
        - Col3
      output: Highest Confidence

Col1	Col2	Col3
['A', 0.79]	['B', 0.77]	['C', 0.99]

Highest Confidence
['C', 0.99]

wrangles:
  - select.highest_confidence:
      input:
        - Col1
        - Col2
        - Col3
      output:
        - Item
        - Confidence

Col1	Col2	Col3
['A', 0.79]	['B', 0.77]	['C', 0.99]

Item	Confidence
C	0.99

Access

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

Technical details

Field	Value
Catalog ID	54
Catalog key	select.highest_confidence
Recipe key	select.highest_confidence
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.highest_confidence
Legacy UUID	00aad85d-8cc8-42e5-86f3-e4ff916e8ac2

Sources

• WranglesPY select.highest_confidence implementation
• Archived select.highest_confidence Markdown

---

Left |select.left

Return characters from the left of text. Strings shorter than the length defined will be unaffected.

Select characters from the left of the input. Using a negative length reverses the side of selection, selecting from the right.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the column(s) to edit.	string, integer, array	—	Yes
output	Name of the output column(s).	string, array, null	null	No
Options
length	Number of characters to include from the left. If negative, this will remove the specified number of characters from the left. May not equal 0.	integer	—	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:
  - select.left:
      input: Column
      output: Result
      length: 3

Column
pudding

Result
pud

Access

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

Technical details

Field	Value
Catalog ID	55
Catalog key	select.left
Recipe key	select.left
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.left
Legacy UUID	5cdd9857-0c77-43bf-80d7-d0a8cb6f980b

Sources

• WranglesPY select.left implementation
• Archived select.left Markdown

---

Length |select.length

Calculate the lengths of data in a column. The length depends on the data type e.g. text will be the length of the text, lists will be the number of elements in the list.

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
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:
  - select.length:
      input: Part Code
      output: Part Code Length

Part Code
'6202'

Part Code Length
4

Access

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

Technical details

Field	Value
Catalog ID	56
Catalog key	select.length
Recipe key	select.length
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.length
Legacy UUID	4d7a5f66-0a4a-40e0-8298-d5c55754423d

Sources

• WranglesPY select.length implementation
• Archived select.length Markdown

---

List Element |select.list_element

Select a numbered element of a list (zero indexed).

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
element	The numbered element of the list to select. Starts from zero. This may use python slicing syntax to select a subset of the list.	integer	0	No
Errors
default	Set the default value to return if the specified element doesn't exist.	string, number, array, object, boolean, 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:
  - select.list_element:
      input: Col1
      output: Second Element
      element: 2 # Zero indexed
      default: F

Col1
['A', 'B', 'C']
['D', 'E']

Third Element
C
F

Access

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

Technical details

Field	Value
Catalog ID	57
Catalog key	select.list_element
Recipe key	select.list_element
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.list_element
Legacy UUID	ec40495d-d29a-4f62-86dd-eafa43cf388a

Sources

• WranglesPY select.list_element implementation
• Archived select.list_element Markdown

---

Right |select.right

Return characters from the right of text. Strings shorter than the length defined will be unaffected.

Select characters from the right of the input. Using a negative length reverses the side of selection, selecting from the left.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the column(s) to edit.	string, integer, array	—	Yes
output	Name of the output column(s).	string, array, null	null	No
Options
length	Number of characters to include from the right. If negative, this will remove the specified number of characters from the right. May not equal 0.	integer	—	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:
  - select.right:
      input: Column
      output: Result
      length: 3

Column
pudding

Result
ing

Access

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

Technical details

Field	Value
Catalog ID	58
Catalog key	select.right
Recipe key	select.right
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.right
Legacy UUID	89ee82ec-3bc5-4bfa-899b-7a1260ef9bdb

Sources

• WranglesPY select.right implementation
• Archived select.right Markdown

---

Sample |select.sample

Return a random sample of the rows.

Return a random sample of the rows

Parameters

Name	Description	Accepted Values	Default	Required
Options
rows	If a whole number, will select that number of rows. If a decimal between 0 and 1 will select that fraction of the rows e.g. 0.1 => 10% of rows will be returned.	integer, number	—	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:
  - select.sample:
      rows: 2

Product	Manufacturer
Ball Bearing	SKF
Bearing Race	Timken
Needle Bearing	Acme Bearings
Roller Bearing	General Bearing Co.

Product	Manufacturer
Ball Bearing	SKF
Needle Bearing	Acme Bearings

wrangles:
  - select.sample:
      rows: .25

Product	Manufacturer
Ball Bearing	SKF
Bearing Race	Timken
Needle Bearing	Acme Bearings
Roller Bearing	General Bearing Co.

Product	Manufacturer
Needle Bearing	Acme Bearings

Access

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

Technical details

Field	Value
Catalog ID	59
Catalog key	select.sample
Recipe key	select.sample
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.sample
Legacy UUID	95a84ab6-a66e-450f-8a4a-7a87e3a77932

Sources

• WranglesPY select.sample implementation
• Archived select.sample Markdown

---

Substring |select.substring

Return characters from the middle of text.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	Name of the column(s) to edit.	string, integer, array	—	Yes
output	Name of the output column(s).	string, array, null	null	No
Options
start	The position of the first character to select. If ommited will start from the beginning and length must be provided.	integer, null	null	No
length	The length of the string to select. If ommited will select to the end of the string and start must be provided.	integer, 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:
  - select.substring:
      input: Column
      output: Result
      start: 2
      length: 3

Column
pudding

Result
udd

wrangles:
  - select.substring:
      input: Column
      output: Result
      start: 2

Column
pudding

Result
udding

wrangles:
  - select.substring:
      input: Column
      output: Result
      length: 3

Column
pudding

Result
pud

Access

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

Technical details

Field	Value
Catalog ID	60
Catalog key	select.substring
Recipe key	select.substring
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.substring
Legacy UUID	8befddf8-602e-4fa9-8f16-4c547210ebec

Sources

• WranglesPY select.substring implementation
• Archived select.substring Markdown

---

Tail |select.tail

Return the last n rows.

Return the last n rows

Parameters

Name	Description	Accepted Values	Default	Required
Options
n	Number of rows to return.	integer	—	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:
  - select.tail:
      n: 2

Product	Manufacturer
Ball Bearing	SKF
Bearing Race	Timken
Needle Bearing	Acme Bearings
Roller Bearing	General Bearing Co.

Product	Manufacturer
Needle Bearing	Acme Bearings
Roller Bearing	General Bearing Co.

Access

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

Technical details

Field	Value
Catalog ID	61
Catalog key	select.tail
Recipe key	select.tail
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.tail
Legacy UUID	60853759-c160-49a4-87eb-036516a9d823

Sources

• WranglesPY select.tail implementation
• Archived select.tail Markdown

---

Threshold |select.threshold

Select the first option if it exceeds a given threshold, else the second option.

Parameters

Name	Description	Accepted Values	Default	Required
I/O
input	List of the input columns to select from.	array	—	Yes
output	Name of the output column.	string	—	Yes
Options
threshold	Threshold above which to choose the first option, otherwise the second.	number	—	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:
  - select.threshold:
      input:
        - Col1
        - Col2
      output: Result
      threshold: .77

Col1	Col2
['A', 0.6]	['B', 0.79]

Result
B

Access

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

Technical details

Field	Value
Catalog ID	62
Catalog key	select.threshold
Recipe key	select.threshold
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	select
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.select.threshold
Legacy UUID	af2a5dcc-0ec0-48d7-8fb4-f58d9c5391d2

Sources

• WranglesPY select.threshold implementation
• Archived select.threshold Markdown

---

Sort |sort

Sort the data.

Sort the data

Parameters

Name	Description	Accepted Values	Default	Required
I/O
by	Name or list of the column(s) to sort by.	string, array	—	Yes
Options
ascending	Sort ascending vs. descending. Specify a list to sort multiple columns in different orders. If this is a list of bools then it must match the length of the by.	boolean, array	—	No
Formatting
ignore_index	Ignore Index value accepted by the runtime.	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:
  - sort:
      by: Price
      ascending: true

Item	Price
Hammer	11.99
Chisel	4.99
Drill	29.99
Wrench	6.99
Saw	13.99

Item	Price
Chisel	4.99
Wrench	6.99
Hammer	11.99
Saw	13.99
Drill	29.99

Access

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

Technical details

Field	Value
Catalog ID	93
Catalog key	sort
Recipe key	sort
Catalog status	active
Lifecycle status	active
Recipe Writer eligible	Yes
Namespace	Root-level
Documentation group	select
Aliases	None
Runtime symbol	wrangles.recipe_wrangles.pandas.sort
Legacy UUID	1dcf06ad-898a-4d83-862c-4774be37a687

Sources

• WranglesPY sort implementation
• Archived sort Markdown