Displaying 7 results from an estimated 7 matches for "json_data_frame".
2018 May 08
0
help with json data from the web into data frame in R
...json data from the example link doesn't convert to a data frame. As seen in the following example
library("rjson")
result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]|?Capital%20of|?Has%20area&format=json")
json_data_frame <- as.data.frame(result)
print(json_data_frame)
which results in:
> library("rjson")
Warning message:
package ?rjson? was built under R version 3.4.4
> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]|?Cap...
2018 May 08
3
help with json data from the web into data frame in R
...uot; into a tabular structure.
--
David.
> As seen in the following example
>
> library("rjson")
> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]|?Capital%20of|?Has%20area&format=json")
> json_data_frame <- as.data.frame(result)
> print(json_data_frame)
>
> which results in:
>
>> library("rjson")
>
> Warning message:
> package ?rjson? was built under R version 3.4.4
>
>> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api...
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 09
1
help with json data from the web into data frame in R
...the example link doesn't convert to a data frame. As seen in the following example
library("rjson")
result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]|?Capital%20of|?Has%20area&format=json")
json_data_frame <- as.data.frame(result)
print(json_data_frame)
which results in:
> library("rjson")
Warning message:
package ?rjson? was built under R version 3.4.4
> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?act...
2018 May 08
0
help with json data from the web into data frame in R
...uot; into a tabular structure.
--
David.
> As seen in the following example
>
> library("rjson")
> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]|?Capital%20of|?Has%20area&format=json")
> json_data_frame <- as.data.frame(result)
> print(json_data_frame)
>
> which results in:
>
>> library("rjson")
>
> Warning message:
> package ?rjson? was built under R version 3.4.4
>
>> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api...
2018 May 08
3
help with json data from the web into data frame in R
...uot; into a tabular structure.
--
David.
> As seen in the following example
>
> library("rjson")
> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]|?Capital%20of|?Has%20area&format=json")
> json_data_frame <- as.data.frame(result)
> print(json_data_frame)
>
> which results in:
>
>> library("rjson")
>
> Warning message:
> package ?rjson? was built under R version 3.4.4
>
>> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api...
2018 May 08
0
help with json data from the web into data frame in R
...> David.
>
>
>> As seen in the following example
>>
>> library("rjson")
>> result <- fromJSON(file = "https://www.semantic-mediawiki.org/w/api.php?action=ask&query=[[Category:City]]|?Capital%20of|?Has%20area&format=json")
>> json_data_frame <- as.data.frame(result)
>> print(json_data_frame)
>>
>> which results in:
>>
>>> library("rjson")
>>
>> Warning message:
>> package ?rjson? was built under R version 3.4.4
>>
>>> result <- fromJSON(file = "...