/Python/Python pandas remove non-numeric characters from multiple columns

Python pandas remove non-numeric characters from multiple columns

# Convert multiple columns to float when they contain non-numeric characters e.g. "R 5 000.00" -> 5000.00
df[['A','B','C','D']] = df[['A','B','C','D']].replace(regex=[r'\D+'], value="").astype(float)

Similar codes

0 vote223 views1 answer
Paystack python
Python
0 vote233 views2 answers
Python read file from same directory
Python
0 vote207 views1 answer
'xml.etree.ElementTree.Element' to string python
Python
0 vote216 views1 answer
Get window coordinates selenium
Python
0 vote226 views1 answer
Drop index in multiindex pandas
Python
4 votes207 views2 answers
How to reinstall a python package
Python
0 vote198 views1 answer
Highlight null/nan values in pandas table
Python
9 votes196 views2 answers
Python readlines without n
Python
2 votes206 views2 answers
Inspect rows in dictionary pthon
Python
2 votes195 views1 answer
Get stats from list
Python