extract_json_values
Extract values from JSON columns using JsonPath.
A JsonPath is a string that uses a syntax similar to XPath to extract values from JSON objects.
The syntax is described in the JsonPath Online Evaluator.
Usage
The following example shows how the step can be used in a recipe.Examples
Examples
Extract all the cities from a column with Json values.
Inputs & Outputs
The following are the inputs expected by the step and the outputs it produces. These are generally columns (ds.first_name), datasets (ds or ds[["first_name", "last_name"]]) or models (referenced
by name e.g. "churn-clf").
Inputs
Inputs
A text column with Json values to extract parts from.
Outputs
Outputs
The column resulting from evaluating the JsonPath expression on the input column.
Configuration
The following parameters can be used to configure the behaviour of the step by including them in a json object as the last “input” to the step, i.e.step(..., {"param": "value", ...}) -> (output).
Parameters
Parameters
JsonPath string used to extract the values from the JSON values of the columns.
Examples
Examples
- address.city
Output column type.
Select the desired type using a shortened yet fully specified name.Values must be one of the following:
boolean category date number text url list[number] list[category] list[url]