对于每个客户ID,数据集都有几行,以及TS.
对于每个客户ID,我想判断Status
列,以判断它是否在该客户ID的前几行中包含Cancelled
值.(由TS订购)
CustomerID | Status | TS |
---|---|---|
Vimes | CANCELLED | Jan 1 |
Vimes | ACTIVE | Jan 2 |
Vimes | CANCELLED | Jan 3 |
Sybill | ACTIVE | Jan 2 |
Sybill | ACTIVE | Jan 5 |
Sybill | ACTIVE | Jan 6 |
结果集应该如下所示,添加了一个带有标志Rejoiner
的列,用于判断Status
列之前的值-
CustomerID | Status | TS | Rejoiner |
---|---|---|---|
Vimes | CANCELLED | Jan 1 | No |
Vimes | ACTIVE | Jan 2 | Yes |
Vimes | CANCELLED | Jan 3 | Yes |
Sybill | ACTIVE | Jan 2 | No |
Sybill | ACTIVE | Jan 5 | No |
Sybill | CANCELLED | Jan 6 | No |