json_lengths {tidyjson}

Compute the length of JSON data

Description

When investigating JSON data it can be helpful to identify the lengths of the JSON objects or arrays, especialy when they are 'ragged' across documents. The json_lengths function adds a column (default name "length") that contains the 'length' of the JSON associated with each row. For objects, this will be equal to the number of name-value pairs. For arrays, this will be equal to the length of the array. All scalar values will be of length 1, and null will have length 0.

Usage

json_lengths(.x, column.name = "length")

Arguments

.x

a json string or tbl_json object

column.name

the name to specify for the length column

Value

a tbl_json object

See Also

json_complexity to compute the recursive length of each value

Examples

# A simple example
json <- c('[1, 2, 3]', '{"k1": 1, "k2": 2}', '1', 'null')

# Complexity is larger than length for nested objects
json %>% json_lengths

# Worldbank objcts are either length 7 or 8
library(magrittr)
worldbank %>% json_lengths %$% table(length)

# All commits are length 8
commits %>% gather_array %>% json_lengths %$% table(length)