Assign output with replace
:
df = df.replace(',','.', regex=True).astype(float)
If want specify columns for converting:
cols = ['col1','col2']
df[cols] = df[cols].replace(',','.', regex=True).astype(float)
Another solution is use parameter decimal=','
in read_csv
, then columns are correctly parsed to floats:
df = pd.read_csv(file, decimal=',')
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…