Creating a New Column in Pandas Using Logical Slicing and Group By by Different Columns