pandas applying regex to replace values

Question

I have read some pricing data into a pandas dataframe the values appear as:

$40,000* $40000 conditions attached 

I want to strip it down to just the numeric values. I know I can loop through and apply regex

[0-9]+ 

to each field then join the resulting list back together but is there a not loopy way?

Thanks

Answer 1

You could use Series.str.replace:

import pandas as pd  df = pd.DataFrame(['$40,000*','$40000 conditions attached'], columns=['P']) print(df) #                             P # 0                    $40,000* # 1  $40000 conditions attached  df['P'] = df['P'].str.replace(r'\D+', '', regex=True).astype('int') print(df) 

yields

       P 0  40000 1  40000 

since \D matches any character that is not a decimal digit.