JSON data in data frame

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]]

--
Regards
Archit

        [[alternative HTML version deleted]]