Replace function is not working in pandas dataframe

Question

I am trying to replace '?' with "'" but the question mark still remains. I am using below code to replace

df['Indication'] = df['Indication'].replace('?', '’')

The resulting column is given below:

Hodgkin?s Lymphoma at high risk of relapse or progression post-ASCT

But the output I want is the following:

Hodgkin's Lymphoma at high risk of relapse or progression post-ASCT

"but it is not working and giving some unwanted result" what is the unwanted result — cs95
– cs95, Commented Jun 9, 2021 at 6:53
@cs95 they provided that in the question, but i can edit it for clarity — Derek O
– Derek O, Commented Jun 9, 2021 at 6:54
@cs95 Hodgkinâ€™s Lymphoma at high risk of relapse or progression post-ASCT — Shivika Patel
– Shivika Patel, Commented Jun 9, 2021 at 8:09

Andrej Kesely · Accepted Answer · 2021-06-09 06:54:14Z

1

Use .str.replace:

df["Indication"] = df["Indication"].str.replace("?", "'", regex=False)
print(df)

Prints:

                                          Indication
0  Hodgkin's Lymphoma at high risk of relapse or ...

answered Jun 9, 2021 at 6:54

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

1 Comment

Hodgkinâ€™s Lymphoma at high risk of relapse or progression post-ASCT