Hi,
want to code the following
assume i have a data set which contains time series date, product id and launch date if the difference between the launch date and date is more than 6 month, we should consider the history of that product and take all records for analysis, else ignore the product.
Product id
date
launch date
1
201710
201710
1
201711
201710
1
201712
201710
1
201801
201710
1
201802
201710
2
201710
201706
2
201711
201706
2
201712
201706
2
201801
201706
2
201802
201706
In the above since product 1 was launched in 201710, and it is not 6 month old, we should ignore the history of this product, while product 2 is already 6 month old now hence we should consider this product.
Thanks in advance
... View more