Creating a New Column Based on Index Values: A Deeper Dive into Pandas DataFrame Manipulation