r - 通过添加 0 扩展数据框

Question

我有一个如下所示的数据框

#   Year A B
# 1 2000 1 1
# 2 2002 0 2
# 3 2005 0 1

我想在两者之间添加年份以生成如下输出:

#   Year A B
# 1 2000 1 1
# 2 2001 0 0
# 3 2002 0 2
# 4 2003 0 0
# 5 2004 0 0
# 6 2005 0 1

Answer 1

使用 complete和 full_seq在 tidyr .

library(tidyr)

complete(df, Year = full_seq(Year, 1), fill = list(A = 0, B = 0))

# A tibble: 6 x 3
   Year     A     B
  <dbl> <dbl> <dbl>
1  2000     1     1
2  2001     0     0
3  2002     0     2
4  2003     0     0
5  2004     0     0
6  2005     0     1