Skip to content
Advertisement

Transform Pandas column to get a key value pair in a column post group by

My DataFrame:

JavaScript

Output required:

JavaScript

Approach tried so far:

JavaScript

Advertisement

Answer

Use GroupBy.apply with lambda function:

JavaScript

Duplicated keys not exist in python dictionary. You can aggregate values, e.g. by sum:

JavaScript
User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement