R中的JSON数据限制在前100行

qf9go6mv 于 2023-10-13 发布在其他

关注(0)|答案(1)|浏览(96)

我正在使用来自US Treasury的API数据。我使用了httr包中的GET()函数和jsonlite包中的fromJSON()函数。下面是一个API示例：

library(httr)
library(jsonlite)
url <- https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/avg_interest_rates

data1 <- GET(url)
data2 <- fromJSON(rawToChar(data1$content))
data2 <- data.frame((data1$data))

问题是我只能看到前100个观测值的数据。输出量：

str(data3)
'data.frame':   100 obs. of  11 variables:
 $ record_date            : chr  "2001-01-31" "2001-01-31" "2001-01-31" "2001-01-31" ...
 $ security_type_desc     : chr  "Marketable" "Marketable" "Marketable" "Marketable" ...
 $ security_desc          : chr  "Treasury Notes" "Treasury Bonds" "Treasury Inflation-Indexed Notes" "Treasury Inflation-Indexed Bonds" ...
 $ avg_interest_rate_amt  : chr  "6.096" "8.450" "3.772" "3.866" ...
 $ src_line_nbr           : chr  "2" "3" "4" "5" ...
 $ record_fiscal_year     : chr  "2001" "2001" "2001" "2001" ...
 $ record_fiscal_quarter  : chr  "2" "2" "2" "2" ...
 $ record_calendar_year   : chr  "2001" "2001" "2001" "2001" ...
 $ record_calendar_quarter: chr  "1" "1" "1" "1" ...
 $ record_calendar_month  : chr  "01" "01" "01" "01" ...
 $ record_calendar_day    : chr  "31" "31" "31" "31" ...

我需要整个可用的数据（不仅仅是前100个观察结果），我无法找出问题所在。API本身不对数据进行限制或强加限制。你能帮帮我吗

r

来源：https://stackoverflow.com/questions/77262613/json-data-in-r-limited-to-first-100-rows

1条答案

按热度按时间

nuypyhwy1#

正如我在上面的评论中所暗示的，这是一个 * 服务器端 * 限制。https://fiscaldata.treasury.gov/datasets/average-interest-rates-treasury-securities/average-interest-rates-on-u-s-treasury-securities上的API文档描述了分页，例如通过请求

url <- paste0("https://api.fiscaldata.treasury.gov/",
              "services/api/fiscal_service/v2/accounting/od/avg_interest_rates")
res1 <- RcppSimdJson::fload(paste0(url,"?page[number]=1&page[size]=1000"))
res2 <- RcppSimdJson::fload(paste0(url,"?page[number]=2&page[size]=1000"))

您请求并获得大小为1000条记录的集的第一页和第二页。

赞(0）回复(0）举报 2023-10-13

我来回答

R中的JSON数据限制在前100行

1条答案

相关问题

热门标签

最新问答