/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 votes315 views2 answers
Python check if internet is available
Python
0 vote278 views1 answer
Add date and time of today in python
Python
0 vote326 views1 answer
How to find number of categories in python
Python
-1 vote312 views1 answer
Randoomforest sklearn
Python
8 votes309 views1 answer
Numpy where
Python
1 vote317 views1 answer
Round godot
Python
-3 votes366 views1 answer
ValueError: With n_samples=0, test_size=0.2 and train_size=None, the resulting train set will be empty. Adjust any of the aforementioned parameters.
Python
0 vote309 views1 answer
Python select columns with no na
Python
9 votes352 views3 answers
Time date year python
Python
0 vote325 views1 answer
Create matrix with complex python
Python