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

Question

I have a dataframe:

 Values 1,2 nan,7,8 4 9,1

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
– jezrael, Commented Jan 22, 2020 at 9:13

U13-Forward · Accepted Answer · 2020-01-22 09:12:52Z

1

Use str.split with expand=True:

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

answered Jan 22, 2020 at 9:12

71.8k15 gold badges100 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1