/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

3 votes142 views1 answer
Python how to find gcd
Python
0 vote158 views1 answer
Pip not downlaoding cryptography wheel macos
Python
0 vote169 views1 answer
Python selenium click on agree button
Python
8 votes148 views1 answer
Negative lookbehind javascript
Python
1 vote143 views1 answer
Compute mfcc python
Python
0 vote143 views1 answer
Set .difference() Operation in python3
Python
10 votes201 views2 answers
Set axis labels python
Python
-1 vote143 views1 answer
Cannot import name 'httpresponse' from 'django.http'
Python
0 vote133 views1 answer
Site:*.instagram.com
Python
1 vote138 views4 answers
Binary search tree in python
Python