/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

3 votes158 views3 answers
Python find file name
Python
12 votes156 views2 answers
Get random float in range python
Python
0 vote165 views1 answer
How to accept invalidfileexception in python
Python
1 vote155 views1 answer
Tqdm command that works both in notebook and lab
Python
0 vote144 views1 answer
Starter is a naive datetime. Use pytz to make it a "US/Pacific" datetime instead and assign this converted datetime to the variable local.
Python
0 vote153 views1 answer
How to collect the index of a pandas dataframe into a list
Python
-1 vote155 views1 answer
Function to scale features in dataframe
Python
3 votes185 views1 answer
How to open webcam with python
Python
0 vote161 views1 answer
Programe to find contagious sum of sequence
Python
0 vote142 views1 answer
Pip.exe The system cannot find the file specified
Python