我有一个数据框,如下所示,我想基于一列创建一个新列
条件
如果两个或多个行包含相同的Column A和Column B的值,并且Column C是唯一的,则应该将行分配给唯一的组名
输入
A B C
Payment Mark 2
Payment Mark 3
Delayed Charles 2
Delayed Charles 4
Held Mark 3
Held Charles 4
Payment Mark 2
Payment Mark 3
Delayed Charles 4
Held Charles 4
期望输出
A B C Cluster
Payment Mark 2 C1
Payment Mark 3 C2
Delayed Charles 2 C3
Delayed Charles 4 C4
Held Mark 3 C5
Held Charles 4 C6
Payment Mark 2 C1
Payment Mark 3 C2
Delayed Charles 4 C4
Held Charles 4 C6
如何在Python中完成这个操作