/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

9 votes322 views6 answers
How to write a function in python
Python
9 votes322 views6 answers
Python absolute path
Python
0 vote333 views1 answer
Request.body django
Python Django
0 vote280 views10 answers
Introduction to distutils in python
Python
8 votes329 views2 answers
Python kivy
Python
0 vote342 views1 answer
Python file write all the bounding box coordinates using OpenCV
Python
0 vote339 views1 answer
How to add zeros in front of numbers in pandas
Python
0 vote334 views1 answer
Python networkmanager tutorial
Python
0 vote318 views2 answers
How to calculate approximate distance with latitude and longitude
Python
3 votes331 views4 answers
Django setup in windows
Python