[R] JSON data in data frame

[Archit Soni]

Hi Jermiah,

When i ran this code in Spotfire, my aim is to get output as a data table.
I am getting the same error:

TIBCO Enterprise Runtime for R returned an error: 'Error in
.cleanDataForExport(value, output.name) : Output data 'tab$coord' has
illegal type: 'data.frame''.


Code that I used:

library(jsonlite)

dat<- fromJSON('
http://api.openweathermap.org/data/2.5/group?id=524901,703448,2643743&units=metric&appid=ec0313a918fa729d4372555ada5fb1f8
')


tab <- dat$list

tab is my output variable that will give me results in table format.

Could you please suggest what we can do to resolve this error.

Many Thanks,
Archit

On Fri, Jan 13, 2017 at 11:23 PM, jeremiah rounds <roundsjeremiah at gmail.com>
wrote:

> I TAd a course in R computing and the first thing I told students was
> "inspect. inspect. inspect."
> d1 <- fromJSON('http://api.openweathermap.org/data/2.5/
> group?id=524901,703448,2643743&units=metric&appid=
> ec0313a918fa729d4372555ada5fb1f8')
> names(d1)
> str(d1)
> d1
> d1$list
> your_data = d1$list
>
> On Fri, Jan 13, 2017 at 1:12 AM, Archit Soni <soni.archit1989 at gmail.com>
> wrote:
>
>> Hi All,
>>
>> Warm greetings, I am stuck at an issue to convert incoming json response
>> to
>> data frame.
>>
>> I am using below code to get the data
>>
>> library(jsonlite)
>> d1 <- fromJSON('
>> http://api.openweathermap.org/data/2.5/group?id=524901,70344
>> 8,2643743&units=metric&appid=ec0313a918fa729d4372555ada5fb1f8
>> ')
>>
>> d2 <- as.data.frame(d1)
>> ​
>> typeof(d2)
>> list
>>
>> can you please guide me how can i get this data into pure data.frame
>> format. The list in d1 has nested data.frame objects.
>>
>> Note: If you are unable to get data from api then can use below json
>> string
>> to test it out:
>>
>> JSON: {"cnt":3,"list":[{"coord":{"lon":37.62,"lat":55.75},"sys":{"
>> type":1,"id":7323,"message":0.193,"country":"RU","sunrise":
>> 1484286631,"sunset":1484313983},"weather":[{"id":600,"main":
>> "Snow","description":"light
>> snow","icon":"13d"}],"main":{"temp":-3.75,"pressure":1005,"h
>> umidity":86,"temp_min":-4,"temp_max":-3},"visibility":8000,"
>> wind":{"speed":4,"deg":170},"clouds":{"all":90},"dt":148429
>> 0800,"id":524901,"name":"Moscow"},{"coord":{"lon":30.52
>> ,"lat":50.43},"sys":{"type":1,"id":7358,"message":0.1885,"co
>> untry":"UA","sunrise":1484286787,"sunset":1484317236},"
>> weather":[{"id":804,"main":"Clouds","description":"overcast
>> clouds","icon":"04d"}],"main":{"temp":-2,"pressure":1009,"hu
>> midity":92,"temp_min":-2,"temp_max":-2},"visibility":9000,"
>> wind":{"speed":4,"deg":250,"var_beg":210,"var_end":270},"
>> clouds":{"all":90},"dt":1484290800,"id":703448,"name":"Kiev"
>> },{"coord":{"lon":-0.13,"lat":51.51},"sys":{"type":1,"id":
>> 5187,"message":0.1973,"country":"GB","sunrise":1484294413,"
>> sunset":1484324321},"weather":[{"id":802,"main":"Clouds","de
>> scription":"scattered
>> clouds","icon":"03n"}],"main":{"temp":0.7,"pressure":1002,"t
>> emp_min":0,"temp_max":2,"humidity":98},"visibility":10000,"
>> wind":{"speed":6.2,"deg":270},"clouds":{"all":40},"dt":
>> 1484290200,"id":2643743,"name":"London"}]}
>>
>> Any help is appreciated.
>>
>> --
>> Regards
>> Archit
>>
>>         [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> 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/posti
>> ng-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>
>
>


-- 
Regards
Archit

	[[alternative HTML version deleted]]