Regex with columns pandas

Question

My question is how I can use the re to replace strings that included in a dataframe:

when I use the re.sub(), it gives me an error:

p = re.compile('New')
p.sub('old', df['Col1'])

Also, I tried using the for loop but the out put was unexpected and displaying the value of the first row in all the other rows:

for i in df['Col1']:
    p.sub('old', i)
    print(i)

I'm sure that I'm missing something.

jezrael · Accepted Answer · 2016-08-24 14:03:26Z

3

I think you can use str.replace, which works also with regex:

df = pd.DataFrame({'Col1':['sss old','dd','old']})
print (df)
      Col1
0  sss old
1       dd
2      old

df.Col1 = df.Col1.str.replace('old','new')
print (df)
      Col1
0  sss new
1       dd
2      new

answered Aug 24, 2016 at 14:03

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

K. ossama Over a year ago

One more question : when i want to use re with the str.startswith. it returns all values false.i.e : df.col1.str.startswith('(N|n)ew'), am i missing something?

jezrael Over a year ago

str.startswith doesnt work with regex.

Collectives™ on Stack Overflow

Regex with columns pandas

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related