/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 vote275 views2 answers
Os
Python
0 vote282 views1 answer
Label_map dict = label_map_util.get_label_map_dict(label_map)
Python
2 votes257 views1 answer
Pychamrfind and replace
Python
0 vote283 views1 answer
How to check nth prime in python
Python
11 votes259 views2 answers
Pickle a dictionary
Python
10 votes326 views5 answers
Zip python
Python
0 vote269 views1 answer
Replace value column by another if missing pandas
Python
1 vote280 views1 answer
String to tuple python
Python
0 vote269 views1 answer
Pygame.K_KP_ENTER
Python
0 vote283 views1 answer
Standardscaler
Python