Joining datasets in range of time.

mfherman · January 22, 2019, 1:48am

As @andresrcs says, it's not entirely clear what your criteria for joining are, but you can accomplish this type of join using the fuzzyjoin package. Take a look at this question and answer for an example of a join based on time intervals:

Tidy way to range join tables, on an interval of dates tidyverse

You can do it with the fuzzyjoin package, which implements various not quite exact matching joins in dplyr syntax. library(tidyverse) library(fuzzyjoin) df1 <- tibble::tribble( ~id, ~category, ~date, 1L, "a", "7/1/2000", 2L, "b", "11/1/2000", 3L, "c", "7/1/2002" ) %>% mutate(date = as.Date(date, format = "%m/%d/%Y")) df2 <- tibble::tribble( ~category, ~other_info, ~start, ~end, "a", "x", "1/1/2000", "12/31/2000", "b", "y", "1/1/2001", "12/31/2001", "c", "z", "1/1/2002", "12/31/2002" ) %>% mutate_at(vars(start, end), as.Date, format = "%m/%d/%Y") fuzzy_left_join( df1, df2, by = c( "category" = "c…