Displaying 20 results from an estimated 4000 matches similar to: "need help with unlist(), losing NULL values"
2018 May 08
0
help with json data from the web into data frame in R
That said, I have two issues to ask for help with:
1) how to ignore cert errors with a fromJSON call
And
2) why the json data from the example link doesn't convert to a data frame. As seen in the following example
library("rjson")
result <- fromJSON(file =
2018 May 08
3
help with json data from the web into data frame in R
> On May 8, 2018, at 9:03 AM, Evans, Richard K. (GRC-H000) <richard.k.evans at nasa.gov> wrote:
>
> That said, I have two issues to ask for help with:
>
> 1) how to ignore cert errors with a fromJSON call
If you can do it with curl, then why aren't you doing one of a) a system call, b) installing and loading RCurl, c) installing and loading curl (the R package with that
2018 May 09
1
help with json data from the web into data frame in R
Regarding the question:
From the linux shell I use the "-k" switch with cURL to ignore cert errors.. is there an equivalent in the R world?
I have (sometimes) had success by creating a .curlrc file and putting the necessary curl options in it. When R invokes curl, curl picks up the options.
[my context was running install.packages( method='curl' ) pointing to a local
2018 May 08
0
help with json data from the web into data frame in R
[non-tabular json data] -- ok.. so I think I need to figure out how to make it tabular. Thanks!
[curl] -- I was hoping there was a cleaner way to do it.. using R to evoke cURL to get the data as text and then passing it into getJSON seems to be what I need to do.
Do you by chance have an simple example of using RCurl to get a response ignoring cert errors?
ty
-Rich
-----Original Message-----
2018 May 08
3
help with json data from the web into data frame in R
Hi David, .. I think I've got it :-)
Please let me know if you see anything glaringly wrong with this:
library(RCurl)
zWebObj <- postForm("https://www.semantic-mediawiki.org/w/api.php",
"action" = "ask",
"query" = "[[Category:City]]|?Capital%20of|?Has%20area",
"format" = "json"
.opts = list(ssl.verifypeer =
2011 Jun 25
2
On .. glibc detected home/sguha/lib64/R/bin/exec/R: realloc(): invalid next size: 0x000000000209e210 ***
Hello,
I'm trying to use rjson to parse a JSON object. The object can be found here
http://pastebin.com/np0s5hgM
(you'll probably need to add quotes around the content)
fromJSON returns the error
glibc detected home/sguha/lib64/R/bin/exec/R: realloc(): invalid next
size: 0x000000000209e210 ***
Is there a fix coming soon? Maybe CRAN should also have an outstanding
bug field -
2018 May 08
3
help with json data from the web into data frame in R
Right. I'm trying to access a server within my organization which has a cert error that I cannot fix.
The example link I provided was to a site on the web that does not have the cert error.
From the linux shell I use the "-k" switch with cURL to ignore cert errors.. is there an equivalent in the R world?
-Rich
-----Original Message-----
From: David Winsemius [mailto:dwinsemius
2018 May 08
0
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
2018 May 08
2
help with json data from the web into data frame in R
I?ve been tinkering and discovered that the link I need to read json data from is ?https? and there is a certificate warning that I have to click through from a browser. That might be my issue. Is there any way in the json package to tell it to ignore self-signed cert errors in a url?
-Rich
From: Eric Berger [mailto:ericjberger at gmail.com]
Sent: Tuesday, May 08, 2018 11:31 AM
To: Evans,
2018 May 08
0
help with json data from the web into data frame in R
> On May 8, 2018, at 8:36 AM, Evans, Richard K. (GRC-H000) <richard.k.evans at nasa.gov> wrote:
>
> I?ve been tinkering and discovered that the link I need to read json data from is ?https? and there is a certificate warning that I have to click through from a browser. That might be my issue. Is there any way in the json package to tell it to ignore self-signed cert errors in a
2018 May 08
0
help with json data from the web into data frame in R
> On May 8, 2018, at 10:08 AM, Evans, Richard K. (GRC-H000) <richard.k.evans at nasa.gov> wrote:
>
> Hi David, .. I think I've got it :-)
> Please let me know if you see anything glaringly wrong with this:
>
> library(RCurl)
> zWebObj <- postForm("https://www.semantic-mediawiki.org/w/api.php",
> "action" = "ask",
>
2012 Dec 01
1
reading json tables
I'm trying to read two data sets in json format from a single .js file.
I've tried fromJSON()
in both RJSONIOIO and RJSON packages, but they require that the lines be
pre-parsed somehow in ways I don't understand. Can someone help?
> wheat <- readLines("http://mbostock.github.com/protovis/ex/wheat.js")
> str(wheat)
chr [1:70] "var wheat = [" "
2012 Dec 04
1
Reading JSON files from R
Hello All -
I am trying to use RJSONIO to read in some JSON files.
I was wondering if anyone could please comment on the level of complexity of
the files it can be used to read, exports from or directly from NoSQL DBMS
like MongoDB and such.
Also, i understand that in reading the JSON file RJSONIO will automatically
create the necessary structures. However I cannot seem to use to to read the
2013 Aug 29
0
Big Integer Support in JSON-to-R Conversion
I have come across an issue converting a JSON string in R (with either the
package 'rjson' or 'RJSONIO') when big integers are included in the JSON
string.
A simple example of the problem is:
> options(scipen=999) # To prevent representing the answer in scientific
notation
> json.str <- '{"bigInt":123456789123456789}' # Sample JSON string with
big
2010 Feb 18
3
parsing strings between [ ] in columns
Dear all,
I have a data.frame with a column like the x shown below
myDF<-data.frame(cbind(x=c("[[1, 0, 0], [0, 1]]",
"[[1, 1, 0], [0, 1]]","[[1, 0, 0], [1, 1]]",
"[[0, 0, 1], [0, 1]]")))
> myDF
x
1 [[1, 0, 0], [0, 1]]
2 [[1, 1, 0], [0, 1]]
3 [[1, 0, 0], [1, 1]]
4 [[0, 0, 1], [0, 1]]
As you can see my x column is composed of
2012 Dec 27
1
Convert json data to an r dataframe
Hello to everybody,
I need to convert a json dataset in an R dataframe.
I suppose that I'd need to use rjson or rjsonio package.
The json dataset is:
http://apistat.istat.it/?q=getdatajson&dataset=DCIS_POPSTRBIL&dim=1,0,0,0&lang=1&tr=&te=
It would be nice if someone can help me to create a function like the one
below:
2018 May 08
2
help with json data from the web into data frame in R
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
2012 Aug 24
1
RJSONIO/rjson maximum depth?
Hi All,
has anyone run into maximum depth of nested JSON arrays in either rjson or
RJSONIO ?
I seem to be able to get up to 10 depth levels without problem, but
crossing over to 11 either causes an error or fails to load the nodes
properly.
with RJSONIO I tried:
a = fromJSON('data/myJSON.json', depth=1000)
but I still get this error:
Error in fromJSON(content, handler, default.size,
2012 Jul 26
2
Get XML or JSON data from api into data frame
Dear all,
I am new to R in general and ways to retrieve XML or JSON data in
particular. I have tried to get information through the XML package
and various websites without being able to do exactly what I want. I
hope someone of you can give me some help.
I want to retrieve information about movies from IMDB or rather the
unofficial api, www.imdbapi.com. I have a vector with a lot movie-ids
2009 Jun 13
1
conditional dependencies & loading
Hi!
I'm working on a package that must convert data to and from JSON. For this,
it can use either the rjson package, or preferably, the faster RJSONIO
package.
I have two related questions about this.
First, how can I specify that the package depends on *either* RJSONIO *or*
rjson? (I.e. both are not required.)
Second, what's the best-practice R idiom for such conditional loading?