/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 vote178 views1 answer
Numpy make 2d array 1d
Python
0 vote194 views1 answer
Python no mathcing key method found
Python
7 votes190 views6 answers
Python random word
Python
1 vote179 views1 answer
Invoice parsing ocr python
Python
0 vote190 views1 answer
Convert integer unix to timestamp python
Python
0 vote233 views1 answer
Using pypyodbc
Python
1 vote197 views1 answer
Requirements.py for flask
Python
0 vote207 views1 answer
Pandas datafdrame pyplot
Python
15 votes191 views2 answers
How to get user ip in python
Python
11 votes221 views4 answers
Python remove empty values from list
Python