Handling Duplicate Values in a Pandas DataFrame When Creating a New Column with Corresponding Values from Other Columns

Reshaping Data with Delimited Values (Reverse Melt) in Pandas Using groupby and pivot_table