如何根据另一行对行进行排序？

Question

请检查这个：How to sequence row based on another row? 输入

Column A     

H            

H            

H            

J            

J            

J            

J            

K   

上面的线程涵盖了公式为： =IF(A2<>A1,1,B1+1)

如果您需要的输出是=IF(A2=A1,1,B1+1)

输出看起来像

Column A     Column B

H            1

H            1

H            1

J            2

J            2

J            2

J            2

K            3

Answer 1

使用shift和cumsum：df["new"] = df["Column A"].ne(df["Column A"].shift(1)).cumsum()print (df)&nbsp; Column A&nbsp; Column B&nbsp; new0&nbsp; &nbsp; &nbsp; &nbsp; H&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; H&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; H&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; 13&nbsp; &nbsp; &nbsp; &nbsp; J&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; 24&nbsp; &nbsp; &nbsp; &nbsp; J&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; 25&nbsp; &nbsp; &nbsp; &nbsp; J&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; 26&nbsp; &nbsp; &nbsp; &nbsp; J&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; 27&nbsp; &nbsp; &nbsp; &nbsp; K&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; 3