Select Wrangles

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

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

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

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

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

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

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
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`	Set the default value to return if the specified element doesn't exist.	string, number, array, object, boolean, null	`null`	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

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

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

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

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

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

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
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`	Set the default value to return if the specified element doesn't exist.	string, number, array, object, boolean, null	`""`	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

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

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

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

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

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

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

Drop​

Parameters​

Examples​

Filter​

Parameters​

Examples​

Columns​

Parameters​

Examples​

Dictionary Element​

Parameters​

Examples​

Element​

Parameters​

Examples​

Group By​

Parameters​

Examples​

Head​

Parameters​

Examples​

Highest Confidence​

Parameters​

Examples​

Left​

Parameters​

Examples​

Length​

Parameters​

Examples​

List Element​

Parameters​

Examples​

Right​

Parameters​

Examples​

Sample​

Parameters​

Examples​

Substring​

Parameters​

Examples​

Tail​

Parameters​

Examples​

Threshold​

Parameters​

Examples​

Sort​

Parameters​

Examples​

Drop

Parameters

Examples

Filter

Parameters

Examples

Columns

Parameters

Examples

Dictionary Element

Parameters

Examples

Element

Parameters

Examples

Group By

Parameters

Examples

Head

Parameters

Examples

Highest Confidence

Parameters

Examples

Left

Parameters

Examples

Length

Parameters

Examples

List Element

Parameters

Examples

Right

Parameters

Examples

Sample

Parameters

Examples

Substring

Parameters

Examples

Tail

Parameters

Examples

Threshold

Parameters

Examples

Sort

Parameters

Examples