/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

2 votes301 views1 answer
Favicon django
Python Django
0 vote323 views1 answer
Add a new categorical column to an existing table python
Python
0 vote261 views1 answer
Demonstrating polymorphism in python class
Python
3 votes278 views1 answer
Jinja2 datetime format
Python
0 vote251 views1 answer
Input np.array
Python
3 votes255 views1 answer
Create virtual env pyhton3
Python
1 vote255 views1 answer
Np to tuple
Python
19 votes260 views6 answers
How to sort a list in python
Python
0 vote271 views1 answer
Subprocess ffmpeg x265 codec
Python
0 vote276 views1 answer
How to calculate the variance of all columns in python
Python