/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 vote158 views1 answer
Linear algebra ipython notebook
Python
70 votes165 views6 answers
Python alphabet
Python
0 vote147 views1 answer
Package python3-pip is not available, but is referred to by another package.
Python
0 vote134 views1 answer
How to extract dictionary value from string in python
Python
0 vote173 views1 answer
Selenium exception handling python
Python
2 votes177 views1 answer
Flask for loops
Python Flask
0 vote137 views1 answer
Pyplot new figure
Python
0 vote163 views1 answer
Getting heading from a webpage in beautifulsoup
Python
0 vote152 views2 answers
Remove element from a list python
Python
0 vote158 views1 answer
Python opendatasets
Python