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

Topic		Replies	Views
Join Dataframes on different IDs within date range New to Julia query , dataframes	1	495	October 4, 2020
Merge dataframes where one value is between two others General Usage question	7	11728	November 22, 2020
Dataframes difficult joins Data data , dataframes , data_structures	3	600	February 10, 2021
Asof join support in DataFrames.jl Data dataframes	9	917	October 13, 2022
Unstack dataframe with combine by the same date General Usage question	1	167	November 23, 2023