请教问题如下:
有两个dataset,一个是经济周期的peak、trough时间,另一个是每个code的日期。现在需要确认每个code的日期是在经济周期的哪一个阶段。例如:
Business cycle:
Boom_start Boom_end Recession_start Recession_end
19600101 19620814 19640519 19641227
19800113 19820320 19880922 19890123
...
20030511 20040609 20070223 20090111
Code_date:
Code Date State
1 19610103 Boom
2 19880205 Recession
3 19860309 midcycle
4 20050822 midcycle
...
希望得到如下结果:
if Boom_start<=date<=Boom_end then state=Boom
if Recession_start<=date<=Recession_end then state=Recession
else state=midcycle
十分感谢!