Pandas Can not sum dataframe

Question

I have dataframe like this.

                                  E   F                                 
    ID    A     B       C     D   E   F
    0    0     ABC    AAA    BCD  1   -
    1    1     ABC    AAA    BCD  4   -  
    2    2     ABC    AAA    BCD  6   -

I print type of dataframe by print(type(df['E'])) it show output like this.

<class 'pandas.core.series.Series'>

I try to sum total value in column E but it show output like this

E146

How to sum data in dataframe column? The correct value should be 11 (1+4+6).

Use df['E'][-3] and sum. The sum function is not working properly on because of the single E character present in the column E of your dataframe. In that case it concatenates the values of the column which results in the output E146. — CodeIt
– CodeIt, Commented Aug 5, 2019 at 4:46

jezrael · Accepted Answer · 2019-08-05 05:23:07Z

4

Use:

print(df['E'].iloc[1:].astype(int).sum())

edited Aug 5, 2019 at 5:23

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

answered Aug 5, 2019 at 4:49

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

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

Comments

Andy L. · Accepted Answer · 2019-08-05 06:09:56Z

0

You may use pd.to_numeric with coerce to flip non-numeric value to NaN and sum will handle NaN by itself

pd.to_numeric(df['E'], errors='coerce').sum()

Out[45]: 11.0

answered Aug 5, 2019 at 6:09

Andy L.

25.3k4 gold badges20 silver badges30 bronze badges

Collectives™ on Stack Overflow

Pandas Can not sum dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related