如何获取从 df2 到 df1 具有匹配 df1 日期的列的值
df1 <- data.frame(a= seq.Date(from = as.Date("2021-08-14"), to = as.Date("2021-08- 20")
, by = 1),
vv= NA,
tv= NA)
df2 <- data.frame(a=as.Date(c("2021-08-14","2021-08-15","2021-08-22",
"2021-08-16","2021-08-17","2021-08-25","2021-08-26")),
vv=c(12,11,13,14,15,16,10),
tv= c(1,2,3,4,5,6,7))
所需输出
df3 <- data.frame(
a = seq.Date(from = as.Date("2021-08-14"), to = as.Date("2021-08-19"), by = 1),
vv = c(12, 11, 14,15, NA,NA),
tv = c(1,2,4,5,NA, NA)
)
你可以使用rows_update
:
library(dplyr)
df1 %>%
rows_patch(semi_join(df2, df1, by = "a"))
返回
a vv tv
1 2021-08-14 12 1
2 2021-08-15 11 2
3 2021-08-16 14 4
4 2021-08-17 15 5
5 2021-08-18 NA NA
6 2021-08-19 NA NA
7 2021-08-20 NA NA
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句