如何在R中检测时间序列数据中的缺失年份?

你可以用 setdiff() .

setdiff(seq(min(x), max(x)), x)
# [1] 2016

数据

x <- c(2012,2013,2014,2015,2017,2018,2019,2020,2021,2022)

使现代化

根据附加请求,代码可以扩展为

yr <- setdiff(seq(min(x), max(x)), x)
if( !length(yr) ) yr <- "no year is missing"

注: 如果 yr 长度为0, !length(yr) 威尔得到 TRUE .

你只需要知道少了哪一年吗?

如果是这样,您可以尝试:

all_years <- seq(2012, 2022, 1)
years_in_column <- c(2012,2013,2014,2015,2017,2018,2019,2020,2021,2022)

all_years[!all_years %in% years_in_column]

setdiff :

years <- c(2012,2013,2014,2015,2017,2018,2019,2020,2021,2022)
all_years <- seq(min(years), max(years))
setdiff(all_years, years)
#> [1] 2016

你可以进来 base R:

df <- data.frame(year = c(2012,2013,2014,2015,2017,2018,2019,2020,2021,2022))
all_years <- seq(min(df$year), max(df$year))
result <- all_years[!all_years %in% df$year]
result
[1] 2016

if(lenth(result) == 0) result <- "no year is missing"