Transform values from 1 column to multiple columns

Question

I have the following table:

and would like to convert the product column to something like:

How would you recomend I do this in pandas? Test df below

import numpy as np
import pandas as pd

test_dict = {'Acount': ['1', '2', '3', '4'], 'Product': [np.nan, 'A','A,B,C', 'C']}
df = pd.DataFrame.from_dict(test_dict)

Answer 1

For a single column you can use Series.str.get_dummies which allows you to specify the character that separates all categories. Set 'Acount' to the index so that appears in the output:

df.set_index('Acount')['Product'].str.get_dummies(sep=',')

        A  B  C
Acount         
1       0  0  0
2       1  0  0
3       1  1  1
4       0  0  1