python - 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+', '').astype('int')
print(df)

yields

       P
0  40000
1  40000

since D matches any non-decimal digit.