Understanding the Issue with Deleting Rows in a Python Dataframe: A Deep Dive into Unexpected Behavior