How to remove integer values from column with pandas

Question

I have a dataframe with info on multiple countries. The data is not very clean and some of the country names have integer values in them. like this China2 or Ukraine18.

I want to remove the integer values from all entries in the Country column but am not able to find a robust way to do this. Any help is appreciated

Mayank Porwal · Accepted Answer · 2021-01-23 06:26:32Z

2

You can use Series.str.replace:

df['Country'] = df['Country'].str.replace('\d+', '')

edited Jan 23, 2021 at 6:26

answered Jan 23, 2021 at 6:22

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

How to remove integer values from column with pandas

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