/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 votes170 views1 answer
Jupyter notebook pass python variable to shell
Python
25 votes176 views6 answers
Python check for integer
Python
0 vote161 views1 answer
Hungarian algorithm python
Python
0 vote209 views1 answer
Remove last comma forloop django
Python Django
0 vote154 views1 answer
Recursively find the factorial of a natural number.
Python
0 vote181 views1 answer
Seaborn pandas annotate
Python
0 vote119 views1 answer
Selenium.common.exceptions.elementclickinterceptedexception: message: element click intercepted:
Python
5 votes157 views3 answers
Object to int64 pandas
Python
0 vote175 views1 answer
Mypy Should never get here in normal mode, got NoneType: instead of TypeInfo
Python
125 votes175 views6 answers
How to take input from user in python
Python