/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

6 votes144 views2 answers
Read data from yaml file in python
Python
0 vote143 views2 answers
The find() method in BeautifulSoup ____.
Python
76 votes199 views6 answers
How to iterate through a list in python
Python
0 vote141 views1 answer
Py insert char at index
Python
1 vote149 views1 answer
Library for converting text into image in python
Python
2 votes159 views2 answers
How to check if number is negative in python
Python
5 votes147 views5 answers
How to use print statement in python
Python
0 vote199 views1 answer
Get processor model in python
Python
0 vote209 views1 answer
Iversao de matriz python
Python
0 vote158 views1 answer
> 'depth' is 6 (CV_64F)
Python