Skip to main content

Accordion

Apply a series of wrangles to column(s) containing lists. The wrangles will be applied to each element in the list and the results will be returned back as a list.

Apply a series of wrangles to the individual elements of one or more lists.

Parameters​

NameDescriptionAccepted ValuesDefaultRequired
I/O
inputThe column(s) containing the list(s) that the wrangles will be applied to the elements of.string, integer, array—Yes
outputOutput of the wrangles to save back to the dataframe.string, array, nullnullNo
propagateLimit the column(s) that will be available to the wrangles and replicated for each element. If not specified, all columns will be propogated. This may be useful to limit the memory use for large datasets.string, array, nullnullNo
Conditions
ifCondition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}.string—No
whereFilter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'.string—No
where_paramsValues used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name.array, object—No
Execution
wranglesList of wrangles to apply.array—Yes

Examples​

This example applies convert.case to each string in a list, where the wrangle would not normally operate on the list as a whole.

wrangles:
- accordion:
input: list_column
output: modified_lists
wrangles:
- convert.case:
input: list_column
output: modified_lists
case: upper
list_column
["a", "b", "c"]
["e", "f", "g"]
modified_lists
["A", "B", "C"]
["E", "F", "G"]
Access
RequirementValue
AI-poweredNo
Requires WrangleWorks accountNo
Requires subscriptionNo
Requires external API keyNo
Technical details
FieldValue
Catalog ID69
Catalog keyaccordion
Recipe keyaccordion
Catalog statusactive
Lifecycle statusactive
Recipe Writer eligibleNo
Recipe Writer exclusionNested-list orchestration is not supported in the baseline.
NamespaceRoot-level
Documentation grouputility
AliasesNone
Runtime symbolwrangles.recipe_wrangles.main.accordion
Legacy UUIDNone

Sources