/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

11 votes407 views6 answers
Django create user
Python Django
0 vote337 views1 answer
Apply same shuffle to two arrays numpy
Python
2 votes332 views1 answer
Python selenium move cursor to element
Python
0 vote370 views1 answer
Una esfera solida de radio 40 cm tiene una carga positiva
Python
0 vote323 views1 answer
Raspberry pi run a python script using ssh
Python
0 vote335 views3 answers
Python with quick sort
Python
0 vote350 views1 answer
How to wirte something 100 times with python
Python
0 vote362 views1 answer
Python red table from pdf
Python
0 vote310 views1 answer
Python loop array 0,101/100
Python
0 vote368 views1 answer
Qq plot using seaborn
Python