做法是 , 判断r是否大于等于15 大于等于15取1 生成 r15 然后con是同一id连续出现大于等于15的次数。
| id | year | qtr | r | r15 | con |
1 | 1997 | 1 | 7 | | |
1 | 1997 | 2 | 8 | | |
1 | 1997 | 3 | 9 | | |
1 | 1997 | 4 | 10 | | |
1 | 1998 | 1 | 11 | | |
1 | 1998 | 2 | 12 | | |
1 | 1998 | 3 | 13 | | |
1 | 1998 | 4 | 14 | | |
1 | 1999 | 1 | 15 | 1 | 4 |
1 | 1999 | 2 | 16 | 1 | 4 |
1 | 1999 | 3 | 17 | 1 | 4 |
1 | 1999 | 4 | 16 | 1 | 4 |
2 | 1996 | 3 | 15 | 1 | 1 |
2 | 1996 | 4 | 14 | | |
2 | 1997 | 1 | 13 | | |
2 | 1997 | 2 | 12 | | |
2 | 1997 | 3 | 14 | | |
2 | 1997 | 4 | 16 | 1 | 4 |
2 | 1998 | 1 | 18 | 1 | 4 |
2 | 1998 | 2 | 20 | 1 | 4 |
2 | 1998 | 3 | 22 | 1 | 4 |
2 | 1998 | 4 | 7 | | |
2 | 1999 | 1 | 17 | 1 | 2 |
2 | 1999 | 2 | 16 | 1 | 2 |