/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 vote340 views1 answer
Pyqt5 update display
Python
21 votes319 views4 answers
Pyautogui install
Python
18 votes315 views3 answers
How to python
Python
-1 vote315 views1 answer
How to create templates in python
Python
0 vote301 views1 answer
Multivariable traces f(x, y) = sin(x)cos(y)
Python
25 votes319 views4 answers
Pandas count the number of unique values in a column
Python
10 votes286 views3 answers
Pandas create new column conditional on other columns
Python
3 votes343 views2 answers
Numpy count the number of 1s in array
Python
0 vote301 views1 answer
Iterrrows
Python
0 vote305 views1 answer
Python how to restart thread
Python