Importing data from a JSON file into R

json r
user313967 picture user313967 · Apr 11, 2010 · Viewed 226.2k times · Source

Is there a way to import data from a JSON file into R? More specifically, the file is an array of JSON objects with string fields, objects, and arrays. The RJSON Package isn't very clear on how to deal with this http://cran.r-project.org/web/packages/rjson/rjson.pdf.

Answer

rcs picture rcs · Apr 11, 2010

First install the rjson package:

install.packages("rjson")

Then:

library("rjson")
json_file <- "http://api.worldbank.org/country?per_page=10&region=OED&lendingtype=LNX&format=json"
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

Update: since version 0.2.1

json_data <- fromJSON(file=json_file)

Related questions

Parse JSON with R

I am fairly new to R, but the more use it, the more I see how powerful it really is over SAS or SPSS. Just one of the major benefits, as I see them, is the ability to get and …

Read More
R convert dataframe to JSON

I have a dataframe that I'd like to convert to json format: my data frame called res1: library(rjson) structure(list(id = c(1, 2, 3, 4, 5), value = structure(1:5, .Label = c("server1", "server2", "server3", "server4", "server5"), class = "factor")), .Names = c("id", "value"), row.names = …

Read More
How to import JSON into R and convert it to table?

I want to play with data that is now saved in JSON format. But I am very new to R and have little clue of how to play with data. You can see below what I managed to achieve. But …

Read More