JSON to data frame in R

Question

I am trying to turn a .json file into a data frame for data visualization.

If I run the below code I get picture 1.

library(jsonlite)

jdata <- fromJSON("test.json")

data <- as.data.frame(jdata)

And when I try to transpose it, I get picture 2.

data2 <- as.data.frame(t(data))

This is how the json looks like raw:

I don't understand why column one has no name or is not part of the data frame (is jsonlite assuming these are tittles?). How can I overcome this?

I need a data frame from the json files:

Column1 (with the dates) | Column2 (I will divide it into values and coordinates

So, I got it to work with `dplyr`, but is there a way jsonlite can do this? — Daniel Vargas, Jul 11 '17 at 15:44
What does your json look like? If you look carefully you can see that in picture 1 the rows holding the timestamp doesn't have a name either — derHugo, Jul 11 '17 at 16:19
pictures aren't code or data unless image processing is the question. there are many examples of how to properly ask questions. — hrbrmstr, Jul 11 '17 at 16:21
@derHugo the name of the whole file is "updates". I updated the question. — Daniel Vargas, Jul 11 '17 at 16:22
That's not a good formatted json than ... You don't have Variable names there but rather a different variable name for each update .... A better (and only usefull) way would look like `{"updates":[ {"time":"2017....", "value":"hello,....." },...]}` — derHugo, Jul 11 '17 at 16:27

score 4 · Accepted Answer · answered Jul 11 '17 at 21:03

4

Try this for the input file test.json

library(jsonlite)
jdata <- read_json("test.json", simplifyVector = TRUE)

answered Jul 11 '17 at 21:03

Prradep

1 Answers1