/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 vote451 views1 answer
How to install flask module in vscode
Python Flask
0 vote321 views1 answer
Make value of two tables unique django
Python Django
1 vote319 views1 answer
How to hit enter in selenium python
Python
0 vote321 views1 answer
Make large 3d plot in python
Python
0 vote296 views1 answer
Qpushbutton pyqt5
Python
3 votes256 views1 answer
Pygame unable to open file mp4
Python
11 votes307 views2 answers
Add pip to path
Python
20 votes324 views5 answers
Remove first character from string python
Python
8 votes298 views2 answers
Numpy.where
Python
114 votes313 views6 answers
Amc price
Python