擅长:python、mysql、java
<pre><code>df.assign(
result=df.groupby(
['OwnerID', 'GroupID']
).AssignmentID.transform(lambda x: x.factorize()[0]) + 1
)
OwnerID GroupID AssignmentID Result result
0 1 10 100 1 1
1 1 10 100 1 1
2 1 10 200 2 2
3 1 20 100 1 1
4 1 20 200 1 2
5 1 20 300 1 3
6 2 30 200 1 1
7 2 30 200 1 1
8 2 40 300 2 1
</code></pre>