Write multiple dataframes to same json object

Question

Using jsonlite package I am able to write a dataframe to json e.g.

library(jsonlite)
library(tidyverse)

mtcars %>% toJSON() %>% write('data/mtcars.json')
diamonds %>% toJSON() %>% write('data/diamonds.json')

My question is, is it possible to add both mtcars and diamonds to the same json object?

Mikko Marttila · Accepted Answer · 2020-11-14 19:52:24Z

4

Yes: put the datasets in a list before serializing to JSON:

library(jsonlite)

datasets <- list(datasets = list(mtcars = mtcars, iris = iris))
write(toJSON(datasets), "datasets.json")

This will result in a JSON file with a structure like:

{
  "datasets": {
    "mtcars": [...],
    "iris": [...]
  }
}

answered Nov 14, 2020 at 19:52

Mikko Marttila

12.2k1 gold badge22 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1