How to split two strings into different columns in Python with Pandas?

Question

I am new to this, and I need to split a column that contains two strings into 2 columns, like this:

Initial dataframe:

    Full String
0   Orange Juice
1   Pink Bird
2   Blue Ball
3   Green Tea
4   Yellow Sun

Final dataframe:

    First String    Second String
0   Orange           Juice
1   Pink             Bird
2   Blue             Ball
3   Green            Tea
4   Yellow           Sun

I tried this but doesn't work:

df['First String'] , df['Second String'] = df['Full String'].str.split()

and this:

df['First String', 'Second String'] = df['Full String'].str.split()

How to make it work? Thank you!!!

sophocles · Accepted Answer · 2021-04-02 15:48:18Z

6

The key here is to include the parameter expand=True in your str.split() to expand the split strings into separate columns.

Type it like this:

df[['First String','Second String']] = df['Full String'].str.split(expand=True)

Output:

    Full String First String Second String
0  Orange Juice       Orange         Juice
1     Pink Bird         Pink          Bird
2     Blue Ball         Blue          Ball
3     Green Tea        Green           Tea
4    Yellow Sun       Yellow           Sun

edited Apr 2, 2021 at 15:48

answered Apr 2, 2021 at 12:28

sophocles

13.9k3 gold badges18 silver badges37 bronze badges

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

1 Comment

Andrew Tulip Over a year ago

Thank you! It works! I will accept the answer in 9 minutes

Netim · Accepted Answer · 2021-04-02 12:30:42Z

0

have you tried this solution ?

https://stackoverflow.com/a/14745484/15320403

df = pd.DataFrame(df['Full String'].str.split(' ',1).tolist(), columns = ['First String', 'Second String'])

answered Apr 2, 2021 at 12:30

Netim

1338 bronze badges

Collectives™ on Stack Overflow

How to split two strings into different columns in Python with Pandas?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related