/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 vote196 views1 answer
Telnet via jump host using python
Python
0 vote262 views1 answer
If keyboard.is_pressed
Python
1 vote204 views1 answer
Python create a matrix with one in diagonal
Python
27 votes210 views4 answers
Python change character in string
Python
0 vote159 views1 answer
How to shift the x axis matplot lib
Python
0 vote208 views1 answer
How to use with statementin python 2.4
Python
0 vote198 views1 answer
How to get the top 100 frequent words on a python dataframe colummn
Python
1 vote213 views4 answers
Flask activ environment
Python
13 votes197 views3 answers
Python memory usage
Python
0 vote194 views1 answer
Python import worldcloud
Python