/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

22 votes125 views4 answers
How to create a string in python
Python
0 vote121 views1 answer
How to add keyboard to python turtle
Python
4 votes139 views2 answers
Make a nested list flat python
Python
0 vote77 views1 answer
Hebrew range
Python
1 vote120 views1 answer
Cv2 add circle to image
Python
0 vote118 views2 answers
Pygame keys keep pressing
Python
0 vote121 views1 answer
Restrict ticks to integers matplotlib
Python
19 votes141 views1 answer
Change list to int in python
Python
0 vote155 views1 answer
Python class tostring
Python
27 votes123 views5 answers
Python array append
Python