Working with complex, hierarchically nested JSON data in R can be a bit of a pain. In this post, I illustrate how you can convert JSON data into tidy tibbles with particular emphasis on what I’ve found to be a reasonably good, general approach for converting nested JSON into nested tibbles. I use three illustrative examples of increasing complexity to help highlight some pitfalls and build up the logic underlying the approach before applying it in the context of some real-world rock climbing competition data.

Continue reading

Author's picture

Hendrik van Broekhuizen

Data scientist WIP, R immigrant & patriotic {tidyverse} and {data.table} dual citizen, eternal student, recovering pedant, occasional musician, rock climbing fanatic, amateur runner, board game enthusiast, and science lover.

Data Scientist

South Africa