/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 vote367 views1 answer
List comprehensions with dates
Python
3 votes342 views2 answers
Python try without except
Python
37 votes331 views6 answers
If __name__ == '__main__' in python
Python
0 vote336 views1 answer
Bag of word scikit learn
Python
0 vote337 views1 answer
Python file hashlib
Python
0 vote306 views1 answer
Print from 1 to n in python
Python
2 votes421 views6 answers
What are args and kwargs in python
Python
0 vote356 views1 answer
Qt convert image to base64
Python
0 vote367 views1 answer
Root = tk.Tk() my_gui = App1(root)
Python
0 vote404 views1 answer
?: (corsheaders.E013) Origin '.' in CORS_ORIGIN_WHITELIST is missing scheme or netloc HINT: Add a scheme (e.g. https://) or netloc (e.g. example.com).
Python