json_unnest_longer: Unnest a JSON array column
In jsontools: Working with JSON Vectors

Description Usage Arguments Value See Also Examples

Unnest a column of JSON arrays in a data frame producing a longer data frame.

json_unnest_longer(
  data,
  col,
  values_to = NULL,
  row_numbers_to = NULL,
  indices_to = NULL,
  ptype = NULL,
  wrap_scalars = FALSE,
  bigint_as_char = bigint_default()
)

`data`	A data frame.
`col`	JSON-column of arrays to extract components from.
`values_to`	Name of column to store vector values. Defaults to `col`.
`row_numbers_to`	Name of column to store the row number before unnesting.
`indices_to`	Name of column to store the array index of each element; note that this starts with 0.
`ptype`	Output type. If `NULL`, the default, the output type is determined by computing the common type across all elements. Use `new_json_array()` resp. `new_json_object()` if you know every element is an array resp. object. Mind that the return type will only be `json2`.
`wrap_scalars`	Should scalar values be wrapped? Note that scalars are only wrapped if either `ptype` is `new_json_array()` or `json2` vector. `ptype` is `NULL` and the elements are a mix of scalar values and arrays.
`bigint_as_char`	Convert big integers to character? The option `jsontools.bigint_as_char` is used as default.

A data frame, or subclass of data frame.

json_unnest_wider()

df <- tibble::tibble(
  x = c("a", "b"),
  json = c("[1, 2]", "[3, 4, 5]")
)
df

df %>%
  json_unnest_longer(
    "json",
    row_numbers_to = "id",
    indices_to = "index"
  )