CODEWITHSUNDEEP
pythondataframe
Mary
Mary

Reputation: 797

cannot change datatype from "from_dict" of dataframe

After df['a'].astype(float) from from_dict cannot be sum the column.
I expected the sum(a) should be 15 not 159 and I just want to show 15 only not whole dataframe table

code

x = [{'a': '1','b1': '2','b2': '3', 'c': '4'},{'a': '5','b1': '6','b2': '7','c': '8'},{'a': '9','b1': '10','b2': '11','c': '12'}]
import pandas as pd
df = pd.DataFrame.from_dict(x)

df['a'] = df['a'].astype(float)
df['total'] = df['a'].sum()
df

code output:

    a   b1  b2  c   total
0   1.0 2   3   4   15.0
1   5.0 6   7   8   15.0
2   9.0 10  11  12  15.0

Data type

df['a'].astype(float)
df.dtypes

a        float64
b1       object
b2       object
c        object
total    object
dtype: object

Expected Result

15

Upvotes: 0

Views: 320

Answers (2)

KAPIL GARG
KAPIL GARG

Reputation: 1

Use df['a']=pd.to_numeric(df['a'],errors='coerce') To change the type

Upvotes: 0

Walid
Walid

Reputation: 728

After converting a to float you should save it like this:

df['a']=df['a'].astype(float)

Upvotes: 1

Related Questions