我正在访问数据的api，但无法访问r中的列
我正在访问数据的api，但无法访问r中的列
提问于 2016-09-12 04:04:00
我使用httr从api访问数据，然后保存这些数据，这样我就可以开始做一些数据验证了。我在访问列和行时遇到了问题，因为数据已经存储为嵌套列表。
query2 <- "this is where my api key in addition to the website I was trying went "
out2 <- GET(url = query2)
http_status(out2)
$category
[1] "Success"
$reason
[1] "OK"
$message
[1] "Success: (200) OK"
dataContent <- content(out2)
names(dataContent)
[1] "Data"
envData <- jsonlite::fromJSON(toJSON(dataContent))
result <- data.frame(envData)
names(result)
[1] "Data.Providers.Name" "Data.Providers.Type"
[3] "Data.Providers.Owner" "Data.Providers.Records"
# when I view the data I can see it in rows and columns
View(result$Data.Providers.Records)
#for some reason its saved as one object and I cannot access individual rows and columns
length(cleanerData)
[1] 1回答 1
Stack Overflow用户
发布于 2016-09-12 04:15:41
我不能用您目前拥有的东西复制您的示例，但是您可能可以通过使用fromJSON的data.frame = TRUE获得您期望的what
query2 <- "api-url"
out2 <- GET(url = query2)
## assuming its JSON content, parse as text and use fromJSON
dataContent <- content(out2, as = "text")
parsed_content <- jsonlite::fromJSON(dataContent, flatten = TRUE)页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/39440143
复制相关文章
相似问题
腾讯云开发者
