help with json data from the web into data frame in R
Hi Rich, Take a look at the function fromJSON found in the rjson package. Note that the Usage in the help page: ?fromJSON names the second argument 'file' but if you look at the description the argument can be a URL. HTH, Eric On Tue, May 8, 2018 at 6:16 PM, Evans, Richard K. (GRC-H000) <
richard.k.evans at nasa.gov> wrote:
Hello I am able to construct a url that points to some data online in the JSON format. See an example at [0]. I would like to work with this data as a dataframe in R. I know that there is a package for handling json data [1] but it assumes the data is in a local file but It is not clear to me how to request the data from the web in an R script and get the json data converted into a data frame in R. Can anyone provide a basic example or some guidance please? -Rich (revansx) [0] https://www.semantic-mediawiki.org/w/api.php? action=ask&query=[[Category:City]]&format=json [1] https://www.tutorialspoint.com/r/r_json_files.htm
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/ posting-guide.html and provide commented, minimal, self-contained, reproducible code.