/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 vote249 views1 answer
Set pixel pygame
Python
0 vote253 views1 answer
How to get a list of all variables in memory python
Python
0 vote259 views1 answer
Get a value using a dictionary key in python
Python
12 votes276 views1 answer
Append a line to a text file python
Python
0 vote256 views1 answer
Using loc pandas
Python
0 vote234 views1 answer
How to count number from 1 to 10 in python
Python
0 vote213 views1 answer
Index is datetime and i want the row number
Python
18 votes257 views3 answers
Dataframe check for nan in iterrows
Python
29 votes263 views2 answers
Insertion sort python
Python
0 vote257 views1 answer
Python repet x time
Python