DataFrame Extract int/number values from string?

Question

I have a df with values in a column.
df :

        a    
0    abc_test_0120_12346
1    def_abc def_0420_9658

I want to take out only int/numbers.
Excepted Output is df :

        a    
0    012012346
1    04209658

"What about "abc_123 def_456"? Is the answer "123456" or "123 456" with the space? — cs95
– cs95, Commented Apr 13, 2020 at 6:04

jezrael · Accepted Answer · 2020-04-13 06:04:38Z

4

Idea is replace non numbers to emty strings:

df['a'] = df.a.str.replace('\D+', '')
print (df)
           a
0  012012346
1   04209658

answered Apr 13, 2020 at 6:04

jezrael

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

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

1 Answer 1