/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 vote109 views1 answer
Check if all elements in array are true python
Python
0 vote117 views1 answer
Intersection between two arrays using numpy
Python
1 vote112 views6 answers
Tuple python
Python
0 vote139 views1 answer
Expected a list of items but got type int . django
Python Django
2 votes113 views2 answers
Convert np shape (a,) to (a,1)
Python
10 votes117 views2 answers
Python get numbers after decimal point
Python
0 vote151 views1 answer
Then generate Django project from the project template of cookiecutter
Python Django
0 vote122 views1 answer
Python running mean pandas
Python
4 votes106 views2 answers
Download python for windows 7 32 bits
Python
0 vote162 views1 answer
Pandas count empty string values
Python