/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

4 votes147 views2 answers
Check installed django version
Python Django
0 vote166 views1 answer
Python enum declare
Python
3 votes184 views10 answers
Rick roll
Python
5 votes172 views2 answers
Forgot django admin password
Python
0 vote178 views1 answer
How to get foregine key field from models
Python
12 votes226 views5 answers
Django-cors-headers
Python Django
0 vote158 views1 answer
Graph skewness detection
Python
6 votes168 views3 answers
Tkinter filedialog filename
Python
0 vote172 views1 answer
Pandas filter on range of values
Python
9 votes171 views3 answers
How to get image in jupyter notebook
Python