In case someone else wants to split a single column (deliminated by a value) into multiple columns – try this:
This answered the question I came here looking for.
Credit to EdChum’s code that includes adding the split columns back to the dataframe.
pd.concat([df[], df.str.split(', ', expand=True)], axis=1)
Note: The first argument
The second argument
df.str.split is the series that you want to split.