/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 vote182 views1 answer
Santhal paragana
Python
0 vote146 views1 answer
Django file upload this field is required
Python
0 vote171 views2 answers
Open file dialog on button click pyqt5
Python
0 vote172 views1 answer
Python : read all the contents of the file into a string (use of 'with open')
Python
2 votes133 views2 answers
Pandas shift column up
Python
0 vote175 views1 answer
Discord command addrole python
Python
0 vote176 views1 answer
Dict comprehensions
Python
0 vote151 views1 answer
Python logging basicConfig+time
Python
3 votes164 views3 answers
Python list contains substring
Python
0 vote174 views2 answers
Discord.py get channel id by channel name
Python