Python or pandas split columns by comma and append into rows

Question

I have a dataset looks like this:

I want to split the second column and then append the values like this using python or pandas:

How could I change it? Thanks

Answer 1

You can make use of explode

df = pd.DataFrame({'A': [1, 2, 3, 4],
                   'B': ['ab,s', 'a,s,d,f', 'rk,lw', 'get,me']})

# Split by each comma
df.B = df.B.str.split(',')
df.explode('B')