Importing data from a JSON file into R

Question

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

User · Answer

packages    library httr  library jsonlite    I have had issues converting json to dataframe csv  For my case I did   Token  lt -  245432532532  source  lt -  http            header type  lt -  applcation json  full token  lt - paste0  Bearer    Token  response  lt - GET n source  add headers Authorization   full token  Accept   h type   timeout 120   verbose    text json  lt - content response  type    text   encoding    UTF-8   jfile  lt - fromJSON text json  df  lt - as data frame jfile    then from df to csv    In this format it should be easy to convert it to multiple  csvs if needed   The important part is content function should have type    text

User · Answer

If the URL is https  like used for Amazon S3  then use getURL  json  lt - fromJSON getURL  https   s3 amazonaws com bucket my json

User · Answer

An alternative package is RJSONIO  To convert a nested list  lapply can help   l  lt - fromJSON     winner   68694999     votes          ts   Thu Mar 25 03 13 01 UTC 2010    user    name   Lamur   user id   68694999             ts   Thu Mar 25 03 13 08 UTC 2010    user    name   Lamur   user id   68694999            lastVote    timestamp  1269486788526  user        name   Lamur   user id   68694999     startPrice  0      m  lt - lapply      l  1   votes       function x  c x user  name    x user  user id    x  ts      m  lt - do call rbind  m    gives information on the votes in your example

User · Answer

jsonlite will import the JSON into a data frame   It can optionally flatten nested objects   Nested arrays will be data frames    gt  library jsonlite   gt  winners  lt - fromJSON  winners json   flatten TRUE   gt  colnames winners   1   winner   votes   startPrice   lastVote timestamp   lastVote user name   lastVote user user id   gt  winners  c  winner   startPrice   lastVote user name        winner startPrice lastVote user name 1 68694999          0              Lamur  gt  winners  c  votes      1                               ts user name user user id 1 Thu Mar 25 03 13 01 UTC 2010     Lamur     68694999 2 Thu Mar 25 03 13 08 UTC 2010     Lamur     68694999

User · Answer

import httr package  library httr    Get the url  url  lt -  http   www omdbapi com  apikey 72bc447a amp t Annie Hall amp y  amp plot short amp r json  resp  lt - GET url    Print content of resp as text  content resp  as    text     Print content of resp  content resp       Use content   to get the content of resp  but this time do not specify   a second argument  R figures out automatically that you re dealing   with a JSON  and converts the JSON to a named R list

User · Answer

First install the RJSONIO and RCurl package    x000D   x000D  install packages  RJSONIO   x000D  install packages   RCurl   x000D   x000D   x000D    Try below code using RJSONIO in console   x000D   x000D  library RJSONIO  x000D  library RCurl  x000D  json file   getURL  https   raw githubusercontent com isrini SI IS607 master books json   x000D  json file2   RJSONIO  fromJSON json file  x000D  head json file2  x000D   x000D   x000D

User · Answer

First install the rjson package   install packages  rjson     Then   library  rjson   json file  lt -  http   api worldbank org country per page 10 amp region OED amp lendingtype LNX amp format json  json data  lt - fromJSON paste readLines json file   collapse        Update  since version 0 2 1  json data  lt - fromJSON file json file

[json] Importing data from a JSON file into R

Examples related to json

Examples related to r