/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 vote209 views1 answer
Dataframe python diplay 2 tables on same line
Python
4 votes201 views2 answers
How to make a screen in pygame
Python
-2 votes212 views2 answers
Where to import reverse_lazy in django
Python
0 vote220 views1 answer
Datetime german format python
Python
0 vote202 views1 answer
How to make python do something every x seconds
Python
4 votes193 views3 answers
Python indexing
Python
2 votes196 views1 answer
How to save query data into dataframe pscopg2
Python
30 votes231 views4 answers
How to convert data type of a column in pandas
Python
0 vote216 views1 answer
Python file back to beginning
Python
21 votes169 views9 answers
Dictionary comprehension python
Python