/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 vote199 views1 answer
NameError: name 'CAP_PROP_FPS' is not defined
Python
0 vote178 views1 answer
Can I activate a function inside the definition of the same function
Python
1 vote177 views1 answer
Lisy in python
Python
0 vote300 views1 answer
Clear cookies selenium python
Python
10 votes165 views3 answers
Pandas create new column conditional on other columns
Python
1 vote188 views2 answers
How to make a game in python
Python
15 votes182 views4 answers
Method for detect that a float number is integer in python
Python
10 votes182 views2 answers
How to find length of number in python
Python
0 vote215 views1 answer
How to resolve This typically means that you attempted to use functionality that needed an active HTTP request. Consult the documentation on testing for information about how to avoid this problem. in thread python
Python
1 vote192 views1 answer
How to print whole year calendar in python
Python