how convert object to float in pandas

Question

base = base["DY"].str.replace(',', '.').astype(float) 

ValueError: could not convert string to float: '6.1%'

How convert string to float in pandas in only column?

Your string seems to contain a '%' sign. Please show some sample input. — DYZ, May 27 '20 at 18:49
You want `6.1%` to be converted into `0.061` or rather `6.1`? — Grzegorz Skibinski, May 27 '20 at 18:49

score 0 · Accepted Answer · edited Jun 04 '20 at 10:03

0

Consider:

import pandas as pd

df=pd.DataFrame({"col": ["4,2", "5.79", "-6,23%", "9.6%"]})

df["col2"]=df["col"].str.replace(",",".").str.replace("%", "*0.01").map(eval)

>>> df

      col    col2
0     4,2  4.2000
1    5.79  5.7900
2  -6,23% -0.0623
3    9.6%  0.0960

edited Jun 04 '20 at 10:03

halfer

19,824
17
99
186

answered May 27 '20 at 18:55

Grzegorz Skibinski

12,624
2
11
34

score 0 · Answer 2 · edited May 27 '20 at 19:30

0

You can use something like this below:-

base = base["DY"].str.replace(',' , '.').replace('%', '').astype(float)

edited May 27 '20 at 19:30

zenwraight

2,002
1
10
14

answered May 27 '20 at 18:57

Wahib Mzali

120
5

I do this: base['DY'] = base['DY'].str.rstrip('%').str.replace(',', ".").astype('float') / 100.0 result ValueError: could not convert string to float: '46.489.4' – Ricardo Proença May 27 '20 at 20:20
is the value 46,489.6 ? – Wahib Mzali May 27 '20 at 21:03

how convert object to float in pandas

2 Answers2