Yeah. The date is the only thing that can use to join 2 datasets. So basically the first dataset has deal_id and announcement_date and the second dataset has date and federal date. The rate for the deal in dataset 1 = the average rate( from dataset2) of 60 days prior to the announcement date. For example: company A has the announcement date 4/1/2019. So the rate for company A = mean of the federal rate from 1/1-4/1/2019
... View more