merge_asof

Also written: pd.merge_asof

A join that matches each row to the nearest earlier (or later) row of another table instead of an exact key. It found which wholesale list price was in force at each order time; both tables must be sorted.