If your top dataframe image is what you have already then this is a simple problem.
df['State'].fillna(method='ffill')
0
solved Repeat the value in column until a change occurs
If your top dataframe image is what you have already then this is a simple problem.
df['State'].fillna(method='ffill')
0
solved Repeat the value in column until a change occurs