/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

2 votes316 views2 answers
Print( n ) in python
Python
1 vote327 views1 answer
Get most repeated instance in a queryset django
Python Django
1 vote286 views1 answer
How to get current CPU and RAM usage in Python?
Python
-2 votes248 views10 answers
Python if string has spaces
Python
1 vote268 views1 answer
Flask form errors
Python
3 votes267 views3 answers
Flask migrate
Python
0 vote297 views1 answer
Create app
Python
0 vote308 views1 answer
Pandas rearrange rows based on datetime index
Python
4 votes696 views1 answer
Set python 3 as default ubuntu
Python
1 vote247 views1 answer
Get int value of char python
Python