/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

1 vote314 views2 answers
Django timezone settings
Python Django
0 vote304 views2 answers
How to make a time limit using renpy
Python
6 votes299 views5 answers
Pandas remove whitespace
Python
1 vote329 views2 answers
How to access cookies in django
Python
1 vote253 views1 answer
Python check if dataframe type
Python
1 vote307 views2 answers
End python print with space
Python
0 vote313 views1 answer
Qt convert image to base64
Python
0 vote307 views1 answer
Image loader RGB transform
Python
-1 vote294 views1 answer
ModuleNotFoundError: No module named 'scipy'
Python
1 vote314 views1 answer
Split a given number in python
Python