/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 vote162 views1 answer
Python node class
Python
2 votes130 views1 answer
Readline in a file
Python
0 vote156 views1 answer
Modules django
Python Django
0 vote122 views1 answer
Python class overwrite length method
Python
0 vote103 views3 answers
How to compare the two key from constant value to list of string in python
Python
5 votes135 views2 answers
How to reset username and password in django admin
Python
2 votes138 views1 answer
Python regex numbers only
Python
2 votes140 views2 answers
How to change key to value and versa in python dictionary
Python
0 vote135 views1 answer
Split df coliumn
Python
0 vote164 views1 answer
Django how to create superuser if does not exists on migration
Python Django