CODEWITHSUNDEEP
jsonrjsonlite
Daniel Vargas
Daniel Vargas

Reputation: 1040

JSON to data frame in R

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)

enter image description here

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

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

enter image description here

This is how the json looks like raw:

enter image description here

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

Upvotes: 3

Views: 8893

Answers (1)

Prradep
Prradep

Reputation: 5696

Try this for the input file test.json

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

Upvotes: 4

Related Questions