/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 vote329 views1 answer
Selection sort python
Python
11 votes342 views2 answers
How to get frequency of each elements in a python list
Python
0 vote377 views1 answer
Install opentracing in python
Python
1 vote290 views1 answer
How to extract data from website using beautifulsoup
Python
115 votes337 views6 answers
Write json to file python
Python
0 vote325 views1 answer
Pyspark import stringtype
Python
0 vote338 views1 answer
How to upload to PyPi with same name
Python
0 vote372 views3 answers
Generate binay image python
Python
24 votes322 views2 answers
Python bs4 install
Python
0 vote341 views1 answer
Python import environment variables
Python