I have a DataFrame (dataframeA) with column of dates, all formatted like this
date
19960826
19960826
19970303
19970320
19970905
and a column of values
values
100
35
11
37
...
and a column of groups
groupK
groupL
groupM
...
Given another DataFrame, dataframeB, with two columns: date in the format yyyymmdd, and group. For each row in dataframeB, how do I graph the values that are within 60 days before and after the date for each group.
i.e. if dataframeB first row is
20050101 groupM
graph (on the Y axis) the values in dataframeA where the date is within 50 days before or after Jan 01 2005, and the group is groupM.