/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 vote264 views1 answer
Python-wordpress-xmlrpc get post id
Python
0 vote242 views1 answer
Set permissions role discord.py
Python
1 vote279 views1 answer
The `.create()` method does not support writable nested fields by default. Write an explicit `.create()` method for serializer `room_api.serializers.roomSerializer`, or set `read_only=True` on nested serializer fields.
Python
2 votes325 views3 answers
Get absolute url django
Python Django
18 votes245 views3 answers
How to python
Python
1 vote251 views1 answer
Add element to heap python
Python
0 vote255 views1 answer
API curl python pandas
Python
6 votes254 views4 answers
Get channel from id discord.py
Python
30 votes260 views2 answers
How do i limit decimals to only two decimals in python
Python
0 vote263 views1 answer
Python json nan
Python