I'm trying to expand records in a dataframe for every possible combination between two columns, and I'm having some trouble.
my dataframe:
|name | product |
|---------|-----------------------|
|John |[cards] |
|Josh |[cards, masks, water ]|
|Debby |[magnet, keys] |
Desired output:
|name | product |
|---------|--------------|
|John |[cards] |
|Josh |[cards] |
|Josh |[masks] |
|Josh |[water] |
|Debby |[magnets] |
|Debby |[keys] |
The dataframe output column entries don't have to be in a list