/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 vote121 views1 answer
Use ipython magic in script
Python
0 vote86 views1 answer
Pandas loop through unique values
Python
2 votes113 views1 answer
Give a function a name python
Python
0 vote127 views2 answers
Messagebox python pyqt
Python
0 vote173 views1 answer
How to install flask module in vscode
Python Flask
0 vote137 views4 answers
Python prevent print output
Python
1 vote131 views1 answer
How to delete print statement from console pythonn
Python
0 vote125 views1 answer
Numpy rolling 2d
Python
0 vote124 views1 answer
How to kill a script if error is hit python
Python
22 votes127 views5 answers
Define a string in python
Python