/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

2 votes99 views3 answers
Solve equation python
Python
0 vote107 views1 answer
Skewness python
Python
0 vote97 views1 answer
Import OpenEXR ModuleNotFoundError: No module named 'OpenEXR'
Python
0 vote138 views1 answer
Discord python bot how to change someone's nickname
Python
2 votes101 views1 answer
Jupyter clear cell output programmatically
Python
1 vote111 views1 answer
How to add three conditions in np.where in pandas dataframe
Python
1 vote100 views1 answer
Multipl excel sheets in pandas
Python
1 vote115 views1 answer
Oython
Python
0 vote95 views1 answer
Join mulitple dataframe pandas index
Python
0 vote111 views1 answer
New column in pandas with where logic
Python