/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 vote222 views1 answer
Generic rectangle
Python
1 vote236 views2 answers
[Errno 13] Permission denied
Python
9 votes220 views2 answers
What does isalpha do in python
Python
1 vote272 views1 answer
Django migrate fake zero
Python Django
0 vote226 views1 answer
Change creation date filesystem py
Python
3 votes252 views1 answer
Python more order of columns
Python
0 vote221 views1 answer
Insert a new row to numpy array in especific position
Python
1 vote245 views1 answer
How to make table using python
Python
27 votes266 views3 answers
Sns set figure size
Python
28 votes245 views3 answers
How to know if a string is a number python
Python