R dplyr 加入日期范围

Question

我要加入两张表xxx和 yyy使用复合唯一键和日期范围。在 sql 中，我只是在连接中指定，但我无法获得 dplyr上类。这可能吗？

test<- inner_join(xxx, yyy, by = c("ID" = "ID",
                               "NRA"="NRA",
                               "date_low">"date",
                               "date_high"<"date"),
                               copy = FALSE)

Answer 1

我们可以使用 fuzzy_inner_join来自 fuzzy_join

library(fuzzy_join)
fuzzy_inner_join(xxx, yyy,
              by = c("ID" = "ID",
                           "NRA"="NRA",
                           "date_low" =  "date",
                           "date_high" = "date"), 
              match_fun = list("==", "==", ">", "<"))