Parse string values as JSON.

Description

Usage

<Expr>$str$json_decode(dtype, infer_schema_length = 100)

Arguments

`dtype`	The dtype to cast the extracted value to. If `NULL`, the dtype will be inferred from the JSON value.
`infer_schema_length`	How many rows to parse to determine the schema. If `NULL`, all rows are used.

Details

Throw errors if encounter invalid json strings.

Value

Expr returning a struct

Examples

library(polars)

df = pl$DataFrame(
  json_val = c('{"a":1, "b": true}', NA, '{"a":2, "b": false}')
)
dtype = pl$Struct(pl$Field("a", pl$Int64), pl$Field("b", pl$Boolean))
df$select(pl$col("json_val")$str$json_decode(dtype))

#> shape: (3, 1)
#> ┌─────────────┐
#> │ json_val    │
#> │ ---         │
#> │ struct[2]   │
#> ╞═════════════╡
#> │ {1,true}    │
#> │ {null,null} │
#> │ {2,false}   │
#> └─────────────┘