我有这样的数据,我需要填写缺失的NA值为DATE
.
ID DAY TIME DATE
<dbl> <dbl> <dbl> <date>
1 1 1 1 NA
2 1 1 2 NA
3 1 1 3 NA
4 1 1 4 NA
5 1 1 5 NA
6 1 2 1 2021-09-25
7 1 2 2 2021-09-25
8 1 2 3 2021-09-25
9 1 2 4 2021-09-25
10 1 2 5 2021-09-25
11 1 3 1 NA
12 1 3 2 NA
13 1 3 3 NA
14 1 3 4 NA
15 1 3 5 NA
16 2 1 1 2022-02-26
17 2 1 2 2022-02-26
18 2 1 3 2022-02-26
19 2 1 4 2022-02-26
20 2 1 5 2022-02-26
21 2 2 1 NA
22 2 2 2 2022-02-27
23 2 2 3 2022-02-27
24 2 2 4 2022-02-27
25 2 2 5 2022-02-27
与DAY
对应的DATE
值对于每个ID
都是不同的.最终的数据集应该如下所示:
# A tibble: 25 × 4
ID DAY TIME DATE
<dbl> <dbl> <dbl> <chr>
1 1 1 1 2021-09-24
2 1 1 2 2021-09-24
3 1 1 3 2021-09-24
4 1 1 4 2021-09-24
5 1 1 5 2021-09-24
6 1 2 1 2021-09-25
7 1 2 2 2021-09-25
8 1 2 3 2021-09-25
9 1 2 4 2021-09-25
10 1 2 5 2021-09-25
11 1 3 1 2021-09-26
12 1 3 2 2021-09-26
13 1 3 3 2021-09-26
14 1 3 4 2021-09-26
15 1 3 5 2021-09-26
16 2 1 1 2022-02-26
17 2 1 2 2022-02-26
18 2 1 3 2022-02-26
19 2 1 4 2022-02-26
20 2 1 5 2022-02-26
21 2 2 1 2022-02-27
22 2 2 2 2022-02-27
23 2 2 3 2022-02-27
24 2 2 4 2022-02-27
25 2 2 5 2022-02-27