我有一年中前7个月的数据,并希望线性外推下5个月的数据。我尝试使用Hmisc软件包中的approxExtrap函数,但不确定如何使用,特别是xout参数应该指定什么。如果可能,基于dplyr的解决方案将是理想的。感谢您的时间。
以下是数据示例:
df <- tibble(pop = c(18968, 18956, 18946, 18934, 18923, 18912, 18901, NA, NA, NA, NA, NA),
date = c("2020-01-01", "2020-02-01", "2020-03-01",
"2020-04-01", "2020-05-01", "2020-06-01",
"2020-07-01", "2020-08-01", "2020-09-01",
"2020-10-01", "2020-11-01", "2020-12-01"))
df$date <- lubridate::as_date(df$date)
library(zoo)
;df %>% mutate(pop2 = na.spline(pop, date))
- G. Grothendieck