/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

31 votes334 views6 answers
Round off python
Python
0 vote327 views1 answer
P = pascal(3, 'upper', exact=False)
Python
0 vote337 views1 answer
Python how to locate and fill a specific column null values
Python
0 vote335 views1 answer
Pandas plot date histogram
Python
0 vote317 views1 answer
Use the index of a dataframe for another dataframe
Python
-1 vote313 views1 answer
Converting jupyter notebook files to python
Python
11 votes329 views6 answers
Python get size of file
Python
0 vote323 views1 answer
Python - change the bin size of an histogram+
Python
0 vote302 views1 answer
Python requirments.txt
Python
0 vote342 views1 answer
Print to the text file using inline file argument
Python