/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 vote218 views1 answer
Aggregation with f() in django rest api
Python Django
7 votes159 views4 answers
Random word generator python
Python
0 vote159 views1 answer
Text generate gpt 2 huggingface
Python
0 vote179 views1 answer
Migrate using other database django
Python
0 vote168 views1 answer
Cannot set `other` if drop=True
Python
0 vote155 views1 answer
%%writefile jupyter
Python
0 vote144 views2 answers
Removing rows dataframe not in another dataframe using two columns
Python
28 votes144 views5 answers
Python style console output
Python
3 votes146 views1 answer
Take array of string in python
Python
0 vote143 views1 answer
Decode in django templates
Python