Name of the column(s) to explode. If multiple columns are included they must contain lists of the same length.
string, integer, array
—
Yes
Options
drop_empty
If true, any rows that contain an empty list will be dropped. If false, rows that contain empty lists will keep 1 row with an empty value. Default False.
boolean
false
No
Formatting
reset_index
Reset the index after exploding. 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.
Split one or more dictionaries into columns. The dictionary keys will be returned as the new column headers. If the dictionaries contain overlapping values, the last value will be returned.
Split a dictionary into columns. The dictionary keys are used as the new column headers.
Name or lists of the column(s) containing dictionaries to be split. If providing multiple dictionaries and the dictionaries contain overlapping values, the last value will be returned.
string, integer, array
—
Yes
output
In columns output_format, this is an optional subset of keys to extract from the dictionary. If not provided, all keys will be returned. Columns can be renamed with the following syntax: output: - key1: new_column_name1 - key2: new_column_name2 In to_lists output_format, this must be two output columns for the keys and values lists. If not provided, Keys and Values will be used.
string, array, null
null
No
Formatting
output_format
How to split the dictionary. columns creates one output column for each dictionary key. to_lists creates two output columns containing lists of keys and values.
string; one of:
columns
to_lists
"columns"
No
Errors
default
Provide a set of default headings and values if they are not found within the input.
object, 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.
Split a list in a single column to multiple columns.
Split a list into multiple columns. If only one output is given, split.list returns the same list it was given, so output should be a list of columns or a column name with a wildcard (*).
Name of the output column(s) If a single column is provided, the results will be returned as a list If multiple columns are listed, the results will be separated into the columns. If omitted, will overwrite the input.
string, array, null
null
No
Options
char
Set the character(s) to split on. Default comma (,) Can also prefix with "regex:" to split on a pattern.
string
","
No
element
Select a specific element or range after splitting using slicing syntax. e.g. 0, ":5", "5:", "2:8:2".
string, integer, null
null
No
inclusive
If true, include the split character in the output. Default False.
boolean
false
No
skip_empty
Whether to skip empty values.
boolean
false
No
Formatting
pad
Choose whether to pad to ensure a consistent length. Default true if outputting to columns, false for lists.
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.
Method to split the list. Options include space, boundary, boundary_ignore_space, custom functions as custom.<function>, or regex patterns as regex:<pattern>.
string; one of:
space
boundary
boundary_ignore_space
or string
"space"
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.