Increment Rank Based on Changes in Flag Column with Pandas Dataframe

Combining Dense_Rank() and Lag() for Efficient Data Updates in SQL Server