conditional string replace in python

Question

I want to replace all "No" from a data frame col. but if col consists for any other string like "No error" then it will remain as it is.

test = ["No","No Error"]
data = pd.DataFrame(test, columns=["text"])
for i in range(len(data["text"])):
    if len(data["text"][i]) == 2:
       data["text"][i] = data["text"][i]).str.replace("No", "Data not available", regex=True)
    else:
       pass
print(data)

I'm getting an error while running the code. I'm able to get the result by using np.where but I've had several other criteria for conditional replace where "np.where" won't work. If I can make the above approach work it'll be great. Any help is greatly appreciated.

That's because you only replace "No" in cells which contain a string that is exactly 2 characters long. Remove this condition and it works. — Martin Wettstein
– Martin Wettstein, Commented Aug 20, 2020 at 8:15

Rakesh · Accepted Answer · 2020-08-20 08:17:30Z

2

Looks like you need np.where

Ex:

test = ["No","No Error"]
data = pd.DataFrame(test, columns=["text"])
data['text'] = np.where(data['text'] == 'No', "Data not available", data['text'])
# OR data.text[data.text=='No'] = "Data not available" 
print(data)

Output:

                 text
0  Data not available
1            No Error

answered Aug 20, 2020 at 8:17

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

1 Comment

Rakesh Over a year ago

Please accept(tick symbol) any one of the ans that helped you. Thanks

sushanth · Accepted Answer · 2020-08-20 08:32:16Z

0

You can also use, Series.replace

data.text.replace({"No":"Data not available"})

0    Data not available
1              No Error
Name: text, dtype: object

answered Aug 20, 2020 at 8:32

sushanth

8,2923 gold badges20 silver badges31 bronze badges

Collectives™ on Stack Overflow

conditional string replace in python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related