/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 vote109 views1 answer
Python ip location lookup
Python
15 votes108 views3 answers
Sum of 2 numbers in python
Python
0 vote125 views1 answer
Python fill string with spaces to length
Python
0 vote120 views1 answer
Check if there is a certain number difference with python
Python
4 votes102 views2 answers
Is coumn exist then delete in datafrmae
Python
0 vote115 views1 answer
Filter one dataframe by another
Python
0 vote101 views1 answer
Rdkit load smiles
Python
0 vote99 views2 answers
Python x y coordinates
Python
2 votes110 views1 answer
How to launch jupyter notebook from cmd
Python
8 votes121 views2 answers
Append two list of number to one python
Python