CODEWITHSUNDEEP
rjson
Canovice
Canovice

Reputation: 10471

How to get public github JSON into R as a list of lists?

I would like to experiment with some soccer data made publicly available by Statsbomb on their github page. Here's a list to one of the JSONs from their github page that is available:

https://raw.githubusercontent.com/statsbomb/open-data/master/data/events/7298.json

My question is, how can I get this into R? I have tried the following:

httr::content(httr::GET("https://raw.githubusercontent.com/statsbomb/open-data/master/data/events/7298.json"))

however, this simply returns a length-1 character vector with the whole JSON squeezed into the string. I would preferably like this as a list of lists. How could I do this?

Thanks !!

EDIT: here is Statsbomb's public github repo - if it helps at all!

Upvotes: 0

Views: 860

Answers (1)

MrFlick
MrFlick

Reputation: 206496

If you want to turn the JSON file in to an R object, you'll need to actually parse the data, not just download the file. the jsonlite library makes this easy

url <- "https://raw.githubusercontent.com/statsbomb/open-data/master/data/events/7298.json"
mydata <- jsonlite::read_json(url)

And then mydata is now a big list with all the parsed values from the JSON object.

Upvotes: 3

Related Questions