/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 vote245 views1 answer
Pytorch squeeze
Python
0 vote243 views1 answer
Adding text cv2
Python
9 votes249 views2 answers
Fill missing values in column pandas with mean
Python
1 vote252 views1 answer
Jupyter consumes 100 disk
Python
0 vote233 views2 answers
Crontab python script
Python
49 votes288 views10 answers
Reddit
Python
-1 vote247 views1 answer
Django model UUID field
Python
0 vote290 views1 answer
Python install minio
Python
10 votes246 views2 answers
How to find length of number in python
Python
2 votes279 views1 answer
Python add unique to list
Python