/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 vote171 views1 answer
Convert sentence to words python
Python
14 votes249 views2 answers
Django static files / templates
Python Django
20 votes265 views3 answers
Download image python
Python
0 vote128 views1 answer
Collecting pipnev
Python
1 vote176 views1 answer
How to set screen brightness automatically depending on battery percentage using python
Python
0 vote193 views1 answer
Printing float number python
Python
4 votes174 views1 answer
Python return -1
Python
3 votes196 views2 answers
Dict_values to list python
Python
1 vote210 views1 answer
How to set class attributes with kwargs python
Python
0 vote182 views1 answer
Master python
Python