/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

16 votes134 views4 answers
Random.choice
Python
9 votes120 views2 answers
Euclidean distance
Python
0 vote111 views1 answer
How to open ndjson file in python
Python
1 vote129 views1 answer
Order by listview django
Python
0 vote126 views1 answer
Tf.get_variable initializer
Python
1 vote133 views2 answers
How to find rows with missing data in pandas
Python
0 vote120 views1 answer
Do while python using dates
Python
0 vote125 views1 answer
Comment a lot of lines python vscode
Python
6 votes109 views6 answers
ModuleNotFoundError: No module named 'Crypto'
Python
0 vote114 views1 answer
Median absolute deviation python
Python