CODEWITHSUNDEEP
pythonpandassplit
Joey
Joey

Reputation: 934

Using str.split for pandas dataframe values based on parentheses location

Let's say I have the following dataframe series df['Name'] column: 

         Name
       'Jerry'
  'Adam (and family)'
'Paul and Hellen (and family):\n'
'John and Peter (and family):/n'

How would I remove all the contents in Name after the first parentheses? 

df['Name']= df['Name'].str.split("'(").str[0]

doesn't seem to work and I don't understand why?

The output I want is 

         Name
       'Jerry'
        'Adam'
    'Paul and Hellen'
    'John and Peter'

so everything after the parentheses is deleted.

Upvotes: 2

Views: 3815

Answers (2)

jezrael
jezrael

Reputation: 862691

Solution with split - is necessary escape ( by \:

df['Name']= df['Name'].str.split("\s+\(").str[0]
print (df)
               Name
0           'Jerry'
1             'Adam
2  'Paul and Hellen
3   'John and Peter

Solution with regex and replace:

df['Name']= df['Name'].str.replace("\s+\(.*$", "")
print (df)
               Name
0           'Jerry'
1             'Adam
2  'Paul and Hellen
3   'John and Peter

\s+\(.*$ means replace from optional whitespace, first ( to the end of string $ to "" - empty string.

Upvotes: 2

Thomas Lehoux
Thomas Lehoux

Reputation: 1196

Use regular expression:

>>> import re
>>> str = 'Adam (and family)'
>>> result = re.sub(r"( \().*$", '', str)
>>> print result
Adam

Upvotes: 0

Related Questions