/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 vote89 views2 answers
Remove vowels in a string python
Python
2 votes125 views2 answers
Get_absolute_url django
Python Django
2 votes97 views1 answer
Get dataframe column into a list
Python
0 vote98 views2 answers
Pandas convert entries in a column after groupby in list
Python
0 vote91 views1 answer
Ppcm python
Python
3 votes106 views1 answer
Django session expire time
Python
1 vote92 views1 answer
Sql alchemy engine all tables
Python
0 vote95 views1 answer
Python input byte array
Python
18 votes109 views6 answers
Create new dataframe from existing dataframe pandas
Python
0 vote89 views1 answer
Pandas fill blanks with zero
Python