replace commas to decimal points in DataFrame columns to make them numeric

Question

import pandas as pd    
df = pd.DataFrame([["one", 1.2, "", "4,3"],
   ["two","1,7", "2,4", 0.55],
   ["three","", 5.4, "3,9"]], 
   columns=['a','b','c','d'])

How can I replace the commas in the columns b to d to points and make these columns numeric? Column a (or any number of leading columns) should be retained untouched (can contain commas as well)

J_Heads · Accepted Answer · 2017-06-06T22:31:07.280

5

import re    

for col in ['b', 'c', 'd']:
    df[col] = pd.to_numeric(df[col].apply(lambda x: re.sub(',', '.', str(x))))

edited Jun 06 '17 at 22:31

answered Jun 06 '17 at 21:26

J_Heads

490
2
11

Thanks, this will do the job with: for col in df.columns[6:]: – ronnydw Jun 06 '17 at 21:40

score 1 · Answer 2 · answered Dec 06 '21 at 01:03

1

Just an update on this topic:

pandas now added a replace method, so we can avoid the use of lambda.

df.replace(to_replace=",", value=".", regex=True)

answered Dec 06 '21 at 01:03

Marromenu

23
6

replace commas to decimal points in DataFrame columns to make them numeric

2 Answers2

Just an update on this topic: