How to replace a exact matching string in Pandas string column

Question

I have a dataframe like

import pandas as pd

data = {"Column1" : ["Income recorded on books this year not included on Schedule K, lines 1 through 11 (itemize):",
                     "a Tax-exempt interest $ Statement #36",
                     "Statement #36"],
        "Column2" : [254, 258, 356]}

df = pd.DataFrame(data)

print(df)



                                                       Column1                                    Column2
0   Income recorded on books this year not included on Schedule K, lines 1 through 11 (itemize):    254
1   a Tax-exempt interest $ Statement #36                                                           258
2   Statement #36                                                                                   356

I want to replace the string $ Statement #36 in the second row

Tried with the

df['Key'] = df['Column1'].str.replace(r'\b$ Statement #36\b', '')

But I'm not able to replace the string in the column

Desired Output

                                                       Column1                                    Column2
0   Income recorded on books this year not included on Schedule K, lines 1 through 11 (itemize):    254
1   a Tax-exempt interest                                                                           258
2   Statement #36                                                                                   356

Andrej Kesely · Accepted Answer · 2021-05-06 10:59:37Z

1

You can escape the $ (it's special character in regex) or use regex=False:

data = {
    "Column1": [
        "Income recorded on books this year not included on Schedule K, lines 1 through 11 (itemize):",
        "a Tax-exempt interest $ Statement #36",
        "Statement #36",
    ],
    "Column2": [254, 258, 356],
}

df = pd.DataFrame(data)

df["Column1"] = df["Column1"].str.replace(" $ Statement #36", "", regex=False)
print(df)

Prints:

                                             Column1  Column2
0  Income recorded on books this year not include...      254
1                              a Tax-exempt interest      258
2                                      Statement #36      356

answered May 6, 2021 at 10:59

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

Comments

Joe Thor · Accepted Answer · 2021-05-06 13:03:19Z

0

The '$' character in regex is reserved so it needs to be escaped by using \$\.

I also set the regex flag to True.


import pandas as pd

data = {"Column1" : ["Income recorded on books this year not included on Schedule K, lines 1 through 11 (itemize):",
                     "a Tax-exempt interest $ Statement #36",
                     "Statement #36"],
        "Column2" : [254, 258, 356]}

df = pd.DataFrame(data)


df['Key'] = df['Column1'].str.replace(r'\$\ Statement #36', '', regex=True)

print(df['Key'])

output of print(df['Key'])

0    Income recorded on books this year not include...
1                                a Tax-exempt interest
2                                        Statement #36

edited May 6, 2021 at 13:03

answered May 6, 2021 at 11:18

Joe Thor

1,2601 gold badge13 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to replace a exact matching string in Pandas string column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related