pandas string replace any value of string after one rounded bracket "Only single Rounded bracket by python

Question

i need to replace any after "(" in pandas dataframe by ""

Tuscaloosa (University of Alabama >> Tuscaloosa and 

df['RegionName']= df['RegionName'].str.replace(r"\s+\(.*\"","")

not work

BENY · Accepted Answer · 2018-09-07 19:36:39Z

1

You can using str.split

s
Out[417]: 
0    Tuscaloosa (University of Alabama >> Tuscaloosa
0    Tuscaloosa (University of Alabama >> Tuscaloosa
0    Tuscaloosa (University of Alabama >> Tuscaloosa
0    Tuscaloosa (University of Alabama >> Tuscaloosa
dtype: object
s.str.split('(',1).str[0]
Out[418]: 
0    Tuscaloosa 
0    Tuscaloosa 
0    Tuscaloosa 
0    Tuscaloosa 
dtype: object

answered Sep 7, 2018 at 19:36

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

user3483203 · Accepted Answer · 2018-09-07 19:41:14Z

1

You can use str.extract (Using data from @Wen):

s.str.extract(r'([^(]+)')

0  Tuscaloosa
1  Tuscaloosa
2  Tuscaloosa
3  Tuscaloosa

answered Sep 7, 2018 at 19:41

user3483203

51.3k10 gold badges72 silver badges104 bronze badges

1 Comment

Mohamed Ibrahim Over a year ago

Thnx alot it's work but i need to know the meaning of that and what is '([^(]+)' means

Collectives™ on Stack Overflow

pandas string replace any value of string after one rounded bracket "Only single Rounded bracket by python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related