/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 vote169 views2 answers
Python dict dot notation
Python
97 votes179 views6 answers
Get json from file python
Python
6 votes183 views1 answer
How to reverse word order in python
Python
0 vote228 views2 answers
Count items in a model django rest
Python Django
5 votes169 views1 answer
Python - convert index to a column
Python
0 vote183 views1 answer
Django dump previous migrations
Python
1 vote178 views1 answer
How to set bgcolor of a widget in pyqt5
Python
2 votes214 views1 answer
Python iterate over object fields
Python
1 vote203 views1 answer
Get all paragraph tags beautifulsoup
Python
0 vote196 views1 answer
Ello
Python