pandas - Python - splitting sentences dataframe into multiple columns

Question

I have sentences in csv that I'd like to split it by the delimiter of spaces.

I've tried using this :-

df2 = df["Text"].str.split()

but it doesnt gave out the ideal result. It shows up like this instead.

I am aware how to do it via power query in excel but I would like to learn how to do similar move using Python.

Here's the ideal result that I'd like to achieve

Answer 1

try this:

df2 = df["Text"].str.split(',', expand=True)