I have df1 and df2 and I want to merge these two df that extract Date_2 in df2 which are within the time period of Date_1 in df1.
df1 looks like:
Period Date_1 Money
1 1/1 50
2 1/15 100
3 1/31 50
4 2/15 60
5 2/28 50
df2 looks like:
Date_2 Money
1/1 50
1/5 200
1/15 100
1/20 300
1/31 50
2/3 300
2/15 60
2/18 200
I would like the output be like:
Period Date Money
1 1/1 50
2 1/5 200
2 1/15 100
3 1/20 300
3 1/31 50
4 2/3 300
4 2/15 60
5 2/18 200
5 2/28 50