/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 vote129 views1 answer
Python Print Variable Using the + operator to join variables
Python
0 vote135 views1 answer
How to create dll from java code
Python
10 votes140 views2 answers
Create dict from json file python
Python
0 vote134 views1 answer
Check how many letters in a string python
Python
-1 vote134 views1 answer
Python encoding declaration
Python
18 votes118 views5 answers
Discord.py get user input
Python
0 vote151 views1 answer
Odoo 12 compute documentation
Python
0 vote136 views1 answer
Load dataset from seaborn
Python
0 vote128 views1 answer
How can i make a list of leftovers that are str to make them int in python
Python
15 votes129 views4 answers
Pil resize image
Python