/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 vote109 views1 answer
Rubik's cube solver python
Python
0 vote143 views1 answer
Find the highest id in model django
Python Django
0 vote121 views1 answer
Python - count number of occurence in a column
Python
0 vote99 views1 answer
Return maximum of three values in python
Python
2 votes115 views2 answers
Pandas sort by list
Python
6 votes103 views6 answers
Python ide
Python
1 vote110 views1 answer
How to do processing on html file using python
Python
1 vote114 views1 answer
Piythin comment
Python
0 vote102 views1 answer
Python draw polygon
Python
0 vote122 views1 answer
Numpy rolling 2d
Python