Pandas dataframe regex replace not working in new version

Question

This code used to work in older pandas versions (0.24.2), but throws error in current version (1.3.0): *ValueError: Series.replace cannot use dict-like to_replace and non-None value*.

import pandas as pd

a = pd.DataFrame([['the quick red fox jumps over the lazy dog','red|over'],['red is the color for danger','red']], columns=['text','match'])
a['text'].replace(r'('+a['match']+')', r'<*\1*>', regex=True, inplace=True)

print(a)

How can I make it work on the newer version?

Anurag Dabas · Accepted Answer · 2021-08-02 12:05:28Z

1

IIUC:

try:

a['text']=a['text'].replace('('+'|'.join(a['match'].tolist())+')', r'<*\1*>', regex=True)

output of a:

    text                                                  match
0   the quick <*red*> fox jumps <*over*> the lazy dog   red|over
1   <*red*> is the color for danger                      red

edited Aug 2, 2021 at 12:05

answered Aug 2, 2021 at 11:52

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

Pandas dataframe regex replace not working in new version

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related