How can i change dtype from object to float64 in a column, using python?

Question

I extracted some data from investing but columns values are all dtype = object, so i cant work with them... how should i convert object to float?

(2558 6.678,08 2557 6.897,23 2556 7.095,95 2555 7.151,21 2554 7.093,34 ... 4 4.050,38 3 4.042,63 2 4.181,13 1 4.219,56 0 4.223,33 Name: Alta, Length: 2559, dtype: object)

What i want is : 2558 6678.08 2557 6897.23 2556 7095.95 2555 7151.21 2554 7093.34 ... 4 4050.38 3 4042.63 2 4181.13 1 4219.56 0 4223.33 Name: Alta, Length: 2559, dtype: float

Tried to use the a function which would replace , for .

def clean(x): x = x.replace(".", "").replace(",",".")

but it doesnt work cause dtype is object

Thanks!

can you clear what is your input and what output you expect ? — Manish Kumar Singh
– Manish Kumar Singh, Commented May 24, 2020 at 19:23

Stef · Accepted Answer · 2020-05-24 19:38:44Z

0

If your local locale uses commas as decimal signs, you can use locale.atof (if not you'll first have to set an appropriate locale):

>>> s = pd.Series(['6.678,08','6.897,23'], name='Alta')
>>> s
0    6.678,08
1    6.897,23
Name: Alta, dtype: object
>>> import locale
>>> locale.setlocale(locale.LC_NUMERIC, '')
'de_DE.UTF-8'
>>> s.apply(locale.atof)
0    6678.08
1    6897.23
Name: Alta, dtype: float64

answered May 24, 2020 at 19:38

Stef

30.9k3 gold badges34 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

zoramind Over a year ago

Ty so much! it really helped me!

VR7 · Accepted Answer · 2020-05-24 19:36:41Z

0

refer to: How to convert datatype:object to float64 in python?

for i in range(0, len(df.columns)):
    df.iloc[:,i] = pd.to_numeric(df.iloc[:,i], errors='ignore')
    # errors='ignore' lets strings remain as 'non-null objects'

this can convert all numerical values to float64 or int64.

answered May 24, 2020 at 19:36

VR7

1123 silver badges16 bronze badges

Comments

Chris R · Accepted Answer · 2020-05-24 19:38:01Z

0

To replace your values, try this. result is your dataframe, col is your column name

result[col] = result[col].apply(lambda x: x.str.replace(".","").str.replace(",","."))

If you need to convert this variable to a float, try this

result[col] = result[col].astype(float)

answered May 24, 2020 at 19:38

Chris R

135 bronze badges

1 Comment

zoramind Over a year ago

Thank u but it didnt work...it keeps appearing ValueError: could not convert string to float: '6.678,08'...

SAYEDA FATIMA · Accepted Answer · 2022-03-21 18:03:03Z

0

That is because there is a comma between the value Because a float cannot have a comma, you need to first replace the comma and then convert it into float result[col] = result[col].str.replace(",","").astype(float)

answered Mar 21, 2022 at 18:03

SAYEDA FATIMA

1

1 Comment

csabinho Over a year ago

Changing the locale seems to be a more useful solution.

Collectives™ on Stack Overflow

How can i change dtype from object to float64 in a column, using python?

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related