How to parse nested JSON to dataframe in R (or using an external tool)?

Question

I was trying to parse several JSONs on a dataframe on R, and I failed miserably.

The files were quite different. Some were quite simple and easy to parse (with library jsonlite), other were heavily nested and I got into much trouble to parse them. I eventually did it (very badly) but it was pain in the ass. And if I use another JSON with different nesting... It doesn't work anymore.

I googled quite a lot and I couldn't find any nice tool for that. There was tidyjson but it's not available anymore. On python with pandas it is simpler but I would like to stay with R.

Question: is there any library that you know of to do this? Or can you recommend an external tool to pre-process the JSONs and then load the result in R?

Thanks in advance! Cheers.

Example JSON

cole · Accepted Answer · 2020-03-15 02:34:22Z

1

Much delayed, but tidyjson is available again. Apologies for the trouble :) As the maintainer, I am pretty biased in my use of tidyjson, but it is my favorite tool for the job.

The tidyr and purrr packages have recently gained some helpful verbs for nested lists as well with pluck, unnest, flatten, pivot_longer, pivot_wider, and friends.

There is a whole article on the topic here:

https://tidyr.tidyverse.org/articles/nest.html

answered Mar 15, 2020 at 2:34

cole

1,7572 gold badges17 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

How to parse nested JSON to dataframe in R (or using an external tool)?

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