/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 vote265 views2 answers
Generate random string with special characters and numbers in python
Python
1 vote188 views1 answer
If a number times a number is true python
Python
0 vote222 views1 answer
How to work with django ornm __in
Python Django
0 vote198 views1 answer
Check if value in dictionary keys python dataframe
Python
2 votes193 views1 answer
Import validation error in django
Python
1 vote210 views2 answers
Dfs algorithm python
Python
1 vote219 views1 answer
Pygame examples
Python
0 vote203 views1 answer
Firestore search query flutter
Python
11 votes211 views6 answers
Linear regression python code
Python
1 vote179 views1 answer
How to read tuples inside lists python
Python