/Python/Pandas increment value on condition

Pandas increment value on condition

In [47]: df['ans'] = (df['ix'] != df['ix'].shift(1)).cumsum()

In [48]: df
Out[48]: 
   index  ix  ans
0      1  pa    1
1      2  pa    1
2      3  pa    1
3      4  pe    2
4      5  fc    3
5      6  pb    4
6      7  pb    4
7      8  df    5

Source: stackoverflow.com

Similar codes

0 vote252 views1 answer
Ctrl c exception python
Python
0 vote222 views1 answer
Django sign up
Python
10 votes240 views1 answer
Registering static files in jango
Python
7 votes242 views1 answer
How to get user location in python
Python
0 vote215 views1 answer
Python immutable dataclass
Python
0 vote227 views1 answer
Python cv2 unblur
Python
5 votes223 views2 answers
Does break stop all loops
Python
0 vote236 views1 answer
2 distinct numbers random number generator python
Python
1 vote223 views1 answer
Reverse key order dict python
Python
1 vote225 views1 answer
How to ungrid something tkinter
Python