/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 vote192 views1 answer
Python return true for list comprehension
Python
0 vote250 views1 answer
Shebang line python
Python
0 vote212 views1 answer
Dictionary with list as value py
Python
0 vote194 views1 answer
Programmatically determining programming languages based on file extensions in python
Python
0 vote298 views1 answer
Sum of values with none
Python
2 votes221 views2 answers
Pandas shift columns down until value
Python
-2 votes285 views6 answers
Django download
Python Django
60 votes211 views5 answers
Python arguments
Python
4 votes218 views1 answer
How to clear a command line python
Python
1 vote182 views1 answer
Plot value counta
Python