Nested JSON to Data Frame

Question

It's the first time I've had to manipulate a .json file, I'm unsure how to transform nested objects into columns. See the example.

library(jsonlite)
TEST < - fromJSON(‘C:/FOLDER/FILE.json’) %>% as.data.frame()

The file is imported correctly, however, some columns, according to the print, have variables nested within the same column. I would like to know how it is possible to transform these variables nested in columns within the file (TEST).

Please show a small reproducible example with expected output — akrun
– akrun, Commented Dec 10, 2021 at 16:36
I would like to show more information, but I cannot (I still don't know) extract this information. When I hover the mouse over this variable, a pop-up appears written: list (name of all variables) — Bruno Avila
– Bruno Avila, Commented Dec 10, 2021 at 16:54
Issue with your image is that we cannot test. So, can only suggest some codes which may or may not work — akrun
– akrun, Commented Dec 10, 2021 at 17:07

deschen · Accepted Answer · 2021-12-10 22:09:32Z

1

You could try:

library(jsonlite)
library(rrapply)

TEST <- rrapply(fromJSON(‘C:/FOLDER/FILE.json’), how = 'melt')

answered Dec 10, 2021 at 22:09

deschen

11.6k5 gold badges32 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Nested JSON to Data Frame

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related