/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 vote153 views1 answer
Scikit learn split data set site:stackoverflow.com
Python
2 votes135 views1 answer
How to call super class constructor in python two classes
Python
0 vote201 views1 answer
Def square_odd(pylist)
Python
0 vote128 views1 answer
Rename files with spaces in a folder python
Python
22 votes143 views4 answers
Join two numpy arrays
Python
2 votes126 views1 answer
Give a function a name python
Python
0 vote132 views1 answer
Rotate matrix 90 degrees clockwise in python
Python
0 vote137 views1 answer
Max sum slice python 5 - autopilot
Python
50 votes136 views6 answers
Print random string from list python
Python
0 vote135 views1 answer
Disbale tkinter textbox
Python