I have a text column which I want to number and increment based on a condition. For example : where ever word "Finished' appears in text column just increment the number.
Sample dataset
Text column |
started running uefhrgfge |
absdbd |
jadhuesahd |
ejuh3w |
eurwe |
finished feuihref |
Started running swhdwe |
dfiogehr |
rgj |
rejgir |
rgmjoeg |
finished swhdwe |
Desired output