/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

1 vote155 views1 answer
How to create a save command in python
Python
1 vote150 views1 answer
Pandas join series
Python
0 vote138 views1 answer
Pyqt5 date-edity
Python
0 vote166 views1 answer
How to let something see on screen with python
Python
5 votes141 views2 answers
Matplotlib background color
Python
0 vote151 views1 answer
Python time-stamp conversion
Python
17 votes156 views4 answers
Substring in python
Python
2 votes147 views2 answers
Django-admin command not found
Python
0 vote174 views1 answer
Django customize the user model
Python
6 votes155 views2 answers
Python check if folder is empty
Python