Say I have two dataframes but I wish to join them such that val2 from Table 2 is merge on to Table 1 if and only if Table2.date < Table1.date and Table2.date is the closest to Table1.date Table 1 date, val1 2021-12-16, 1 2021-12-16, 2 2021-12-16, 3 Table 2 date, val2 2021-12-14, 1 2021-12-15, 2 …

Functions to merge DataFrames by nearest date that is earlier?

nilshg December 16, 2021, 1:36pm 3

Similar previous discussion here:

1 Like