My df包含一列(V5),其中包含所有缺失的值:
> df
# A tibble: 7 × 5
V1 V2 V3 V4 V5
<dbl> <dbl> <dbl> <dbl> <lgl>
1 1.19 2.45 0.83 0.87 NA
2 1.13 0.79 0.68 5.43 NA
3 1.18 1.09 1.04 NA NA
4 1.11 1.1 4.24 NA NA
5 1.16 1.13 NA NA NA
6 1.18 NA NA NA NA
7 1.44 NA 9.17 NA NA
我想用前面几列中最接近的非缺失值来填充V5列:
> df1
# A tibble: 7 × 5
V1 V2 V3 V4 V5
<dbl> <dbl> <dbl> <dbl> <dbl>
1 1.19 2.45 0.83 0.87 0.87
2 1.13 0.79 0.68 5.43 5.43
3 1.18 1.09 1.04 NA 1.04
4 1.11 1.1 4.24 NA 4.24
5 1.16 1.13 NA NA 1.13
6 1.18 NA NA NA 1.18
7 1.44 NA 9.17 NA 9.17
有similar个帖子,但没有一个能帮助解决这个问题.所以任何线索都将不胜感激.
以下是dput:
structure(list(V1 = c(1.19, 1.13, 1.18, 1.11, 1.16, 1.18, 1.44
), V2 = c(2.45, 0.79, 1.09, 1.1, 1.13, NA, NA), V3 = c(0.83,
0.68, 1.04, 4.24, NA, NA, 9.17), V4 = c(0.87, 5.43, NA, NA, NA,
NA, NA), V5 = c(NA_character_, NA_character_, NA_character_,
NA_character_, NA_character_, NA_character_, NA_character_)), row.names = c(NA,
-7L), class = c("tbl_df", "tbl", "data.frame"))