0

The figure below show is the csv file that contain dataset that have 7 variable, this dataset contain jason data at column number 3 which is order_list variable

enter image description here

My question is how to parse the jarson data in column 3 which is order_list variable of this dataset.

what i already do :

library(jsonlite)

df2 <- purrr::map(df$order_list, jsonlite::fromJSON)

str(df2)

enter image description here

the column 3 still remain as jason data.

ahmad ilman ashraf bin fauzi
  • 27
  • 1
  • 4
  • Please don't paste data as images. It's not helpful to anybody hoping to answer your question - see https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – thelatemail Feb 24 '22 at 01:00

1 Answers1

0

As you saw, fromJSON returns a list. If you want it as a data.frame or tibble you can pipe its output into as.data.frame() or as_tibble(), from the tibble package.

jsonlite::fromJSON("https://us.api.iheart.com/api/v3/live-meta/stream/2501/currentTrackMeta?defaultMetadata=true")
rdelrossi
  • 1,089
  • 1
  • 7
  • 17