This is the Original Set 1 5 2017-01-01 new 1 5 2017-01-07 repeat 1 1 2018-01-17 repeat 2 1 2017-01-01 new 2 1 2017-01-02 other 2 1 2018-01-01 repeat 2 1 2018-01-07 repeat 3 2 2001-01-05 repeat 3 2 2020-01-03 new 3 2 2020-04-01 new This is the result 1 10 2017-01-01 new 1 1 2018-01-17 repeat 2 1 2017-01-01 new 2 1 2018-01-01 repeat 2 1 2017-01-02 other 2 2 2018-01-01 repeat 3 2 2001-01-05 repeat 3 2 2020-01-03 new 3 2 2020-04-01 new Sorry about the ambiguous description. Please be aware of there's other Type out there, so I added one other here. The logic is simple, for one ID , if there are observations for new or repeat ,and these observations have time stamp within one month. Then I consider those observation as one, so I add the amount and take the date and type of the first observation (timely most oldest)
... View more