Replacing multiple values in pandas column at once

Question

This is an incredibly basic question but after reading through Stack and the documentation for str.replace, I'm not finding the answer. Trying to drop all of the punctuation in a column. What would be the proper syntax for this?

This works but it's absurd: igog['text']=igog['text'].str.replace(",","").str.replace("/","").str.replace(".","").str.replace("\"","").str.replace("?","").str.replace(";","")

This doesn't: igog['text'] = igog['text'].str.replace({","," ","/","",".","","\"","","?","",";",""}).

Because I keep getting "replace() missing 1 required positional argument: 'repl'".

Thanks in advance!

Use regular expression igog['text'].str.replace("[,/.\?;]", "") — akuiper
– akuiper, Commented Apr 27, 2021 at 21:15

zoldxk · Accepted Answer · 2021-04-27 21:33:42Z

2

You can make a simple loop like this:

t=",/.\?;"
for i in t:
   igog[text]=igog[text].replace(i,"")

or you can use regex:

igog['text'].str.replace("[,/.\?;]", "")

or you can use re.sub():

import re
igog['text'] = re.sub('[,/.\?;]', "", igog['text'])

or you can define a translation table :

igog['text'].translate({ord(ch):' ' for ch in ',/.\?;'})

edited Apr 27, 2021 at 21:33

answered Apr 27, 2021 at 21:16

zoldxk

2,0501 gold badge10 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Replacing multiple values in pandas column at once

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related