I have a dataframe df that looks like this:
ID | Months | Borrow_Rank |
---|---|---|
1 | 0 | 1 |
1 | 1 | 1 |
1 | 2 | 1 |
2 | 0 | 1 |
2 | 1 | 1 |
2 | 2 | 1 |
3 | 0 | 2 |
3 | 1 | 2 |
4 | 0 | 1 |
4 | 1 | 1 |
I want to create a new variable Months_Adjusted that starts counting from 0 for as long as Borrow_Rank remains the same.
ID | Months | Borrow_Rank | Months_Adjusted |
---|---|---|---|
1 | 0 | 1 | 0 |
1 | 1 | 1 | 1 |
1 | 2 | 1 | 2 |
2 | 0 | 1 | 3 |
2 | 1 | 1 | 4 |
2 | 2 | 1 | 5 |
3 | 0 | 2 | 0 |
3 | 1 | 2 | 1 |
4 | 0 | 1 | 0 |
4 | 1 | 1 | 1 |
Thank you all and I apologise if I could have written the question better. This is my first post.