/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 vote262 views1 answer
How to solve trig equations with jupyter notebook
Python
0 vote244 views1 answer
Python loop array 0,101/100
Python
0 vote248 views1 answer
Add prefix to names in directory python
Python
-1 vote270 views1 answer
Python import from string
Python
1 vote271 views2 answers
Pyqt5 messagebox settext
Python
1 vote279 views1 answer
Flask render error template
Python
8 votes264 views3 answers
How to get index in python
Python
9 votes271 views1 answer
Save an image in python as grayscale cv2
Python
11 votes269 views1 answer
In between in python
Python
0 vote271 views1 answer
How can space be bent
Python