/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

-1 vote190 views1 answer
Comment faire pour retourner une liste python
Python
0 vote223 views1 answer
Recursively find the factorial of a natural number.
Python
0 vote190 views1 answer
Add_node python
Python
0 vote199 views1 answer
Sort eigenvalues and eigenvectors python
Python
0 vote201 views1 answer
Herons rule python
Python
0 vote188 views1 answer
Shared a local host django
Python
0 vote195 views1 answer
Rails in groups of
Python
1 vote181 views1 answer
Pycharm rename file
Python
0 vote220 views1 answer
Django update field after save
Python Django
0 vote205 views1 answer
Python get file name without dir
Python