Split a pandas column into multiple separate columns depending on number of values

Question

I have a dataframe:

How can I split this column so that each value is now in its own column?

               col1       col2     col3 
                1         2
                nan       7          8
                4
                9         1

The only answers I have found are about splitting a column into two columns. How to split a column into two columns?

If check more answers there is also solutions for multiple columns — jezrael, Jan 22 '20 at 09:13

score 1 · Accepted Answer · answered Jan 22 '20 at 09:12

1

Use str.split with expand=True:

print(df['Values'].str.split(',', expand=True))

answered Jan 22 '20 at 09:12

U12-Forward

65,118
12
70
89

Split a pandas column into multiple separate columns depending on number of values

1 Answers1