/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 vote267 views2 answers
Split paragraphs in python
Python
0 vote246 views1 answer
No module named cbor2 windows
Python
1 vote259 views2 answers
Pyqt message box set detailed text
Python
1 vote285 views1 answer
How to change the favicon in flask
Python Flask
17 votes264 views6 answers
Odd or even in python
Python
0 vote229 views1 answer
Python open file same folder
Python
1 vote237 views1 answer
Python make button do more than one command
Python
0 vote255 views1 answer
How to read then overwrite a file with python with truncate
Python
0 vote231 views1 answer
Set permissions role discord.py
Python
25 votes233 views6 answers
Fibonacci
Python