Python Pandas Split strings into two Columns using str.split()

Hi I have run this tiny test and seems to work; note the space and the \ in the split string.

import pandas as pd
df = pd.Series(['Boys (Target)','Womens (DSW)','Girls (Kohls)'])
print(df)
d1 = df.str.split(' \(')
print(d1)

Try this:

import pandas as pd

# creating the df
item = ['coat','boots']
dec = ["Boys (Target)", "Womens (DSW)"]
df = pd.DataFrame(item, columns=['Item'])
df['Description'] = dec


def extract_brackets(row):
    return row.split('(', 1)[1].split(')')[0].strip()


def extract_first_value(row):
    return row.split()[0].strip()


df['Retailer'] = df['Description'].apply(extract_brackets)
df['Description'] = df['Description'].apply(extract_first_value)

print(df)

You have to include the parameter expand=True within split function, and rearrange the way you assign back your two columns. Consider using the following code:

df[['Description','Retailer']]  = df.Description.str.replace(')','',regex=True)\
    .str.split('(',expand=True)

print(df)

    Item Description Retailer
0   coat       Boys    Target
1  boots     Womens       DSW
2  socks      Girls     Kohls
3  shirt       Mens   Walmart
4  boots     Womens       DSW
5   coat       Boys    Target

I am first removing the closing bracket from Description, and then expanding based on the opening bracket.

One way using pandas.Series.str.findall:

df[["Description", "Retailer"]] = df["Description"].str.findall("\w+").apply(pd.Series)
print(df)

Output:

    Item Description Retailer
0   coat        Boys   Target
1  boots      Womens      DSW
2  socks       Girls    Kohls
3  shirt        Mens  Walmart
4  boots      Womens      DSW
5   coat        Boys   Target