[Python] I have a pandas column with lists. Group rows that contains atleast one common...

I have pandas df with 1 column with lists. I would like to group all lists which have at least one element in common.

Input Df :
>
Category
0 [IAB19, IAB81, IAB82]
1 [IAB25, IAB27]
2 [IAB19, IAB20]
3 [IAB22, IAB55, IAB56, IAB58]
4 [IAB81, IAB89]
5 [IAB82, IAB95]


i want to find out if any codes in df['Category'] is present in any other row of df['Category'].

And if yes , I would want to merge those lists sharing at least 1 common element.

Expected Output :

Category
0 [IAB19, IAB81, IAB82, IAB20, IAB89, IAB95]
1 [IAB25, IAB27]
2 [IAB22, IAB55, IAB56, IAB58]


Any thoughts ?

Continue reading...