Pandas not replacing the string correctly

Question

This my pandas dataframe:

print(top)

Result:

Countries	Population
China[B]	1376
India	1200

I want to remove the '[B]' from China, and for that, I ran the following code:

top['Countries'] = top['Countries'].str.replace('[B]', '')

But the result was unsatasfying:

Countries	Population
China[]	1376
India	1200

I also received the following warning:

C:\Users\walde\AppData\Local\Temp/ipykernel_8068/4262663465.py:1: FutureWarning: The default value of regex will change from True to False in a future version.

What´s wrong here?

timgeb · Accepted Answer · 2021-12-18 12:59:53Z

2

'[B]' is treated as a regular expression, which in this case means all characters within the brackets will be replaced (which is just B).

Use regex=False.

answered Dec 18, 2021 at 12:59

timgeb

79.2k20 gold badges129 silver badges150 bronze badges

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

Collectives™ on Stack Overflow

Pandas not replacing the string correctly

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