Python replace non digit character in a dataframe [duplicate]

Question

I have the following dataframe column

>>> df2['Age]

1    25
2    35
3    48 y
4    34 yea
5    29
...

I just want to keep the number en replace the value in df2['Age] like that

My code doesn't work :

df2.Age.replace('^.*','^[0-9]*[0-9]',regex=True,inplace=True)

here's the result

 1    ^[0-9]*[0-9]
 2    ^[0-9]*[0-9]
 3    ^[0-9]*[0-9]
 4    ^[0-9]*[0-9]
 5    ^[0-9]*[0-9]
 ...

Thanks for any help in advance

jezrael · Accepted Answer · 2018-07-25 10:51:09Z

2

Use \D+ for replace non numeric to empty string:

df2.Age.replace('\D+','',regex=True,inplace=True)
print (df2)
  Age
1  25
2  35
3  48
4  34
5  29

answered Jul 25, 2018 at 10:51

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

Rakesh · Accepted Answer · 2018-07-25 10:53:40Z

2

Using str.extract

Ex:

import pandas as pd

df = pd.DataFrame({"Age": ['25', '35', '48 y', '34 yea', '29']})
df["Age"] = df["Age"].str.extract(r"(\d+)", expand=False)
print(df)

Output:

edited Jul 25, 2018 at 10:53

answered Jul 25, 2018 at 10:48

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

Collectives™ on Stack Overflow

Python replace non digit character in a dataframe [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related