如下:a、b、c是原始数据,首尾差和编号是想获得的列。其中当a相同时,对b列连续TRUE对应的c列,计算首尾差。并且首尾差大于2时,进行编号。谢谢帮助!
a | b | c | 首尾差 | 编号 |
2013051500_20 | FALSE | 123.8 |
|
|
2013051500_20 | TRUE | 120 | 3 | 1 |
2013051500_20 | TRUE | 124 | 3 | 1 |
2013051500_20 | TRUE | 125 | 3 | 1 |
2013051500_20 | TRUE | 123 | 3 | 1 |
2013051500_20 | FALSE | 125.05 |
|
|
2013051500_20 | FALSE | 125.3 |
|
|
2013051500_20 | TRUE | 125 | 5 | 2 |
2013051500_20 | TRUE | 130 | 5 | 2 |
2013051500_62 | FALSE | 103.9 |
|
|
2013051500_62 | FALSE | 103.8 |
|
|
2013051500_64 | TRUE | 103.8 | 0 |
|
2013051500_64
| FALSE | 103.87 |
|
|
2013051500_64 | FALSE | 103.93 |
|
|
2013051500_64 | FALSE | 104.05 |
|
|
2013051500_64 | FALSE | 104.14 |
|
|
2013051500_64 | FALSE | 104.3 |
|
|
2013051500_80 | TRUE | 102 | 4 | 3 |
2013051500_80 | TRUE | 106 | 4 | 3 |
2013051500_80 | TRUE | 106 | 4 | 3 |
|
|
|
|
|