/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 vote271 views1 answer
Numpy python 3.10
Python
0 vote199 views1 answer
How to convert into grayscale opencv
Python
3 votes193 views1 answer
Replace "-" for nan in dataframe
Python
1 vote227 views1 answer
Get a list of open applications python
Python
0 vote193 views1 answer
Python how to dump exception stak
Python
0 vote201 views1 answer
Balancing paranthesis python
Python
-1 vote209 views1 answer
Python launch prompt
Python
1 vote207 views1 answer
Python list remove at index
Python
1 vote205 views1 answer
Insert missing data in pandas
Python
0 vote195 views1 answer
How to get the positions where values of two columns match?
Python