unable to get sum of values in a column of dataframe

Asked Oct 12 '18 at 09:11

Active Oct 12 '18 at 10:20

Viewed 53 times

I am trying to write a code in python to sum the values of a feature in pandas. the data inside the feature are say 55, 60, 8, 15 and the name of the feature is say age_col. the age_col.sum() gives following result. 5560815 using for loop as

for i in range(len(age_col)):
     sum += age_col[i]

gives following error

"TypeError: unsupported operand type(s) for +: 'int' and 'str'" dtype returns data type 'object'.

I also used all the methods to convert it into float or numeric value.

Please help

edited Oct 12 '18 at 10:20

khaled_bhar

asked Oct 12 '18 at 09:11

Anand Srivastava

Thank you. I used this conversion but the same error appears. – Anand Srivastava Oct 12 '18 at 10:11
I used "age_col.astype('float64', error='raise', inplace=True)" – Anand Srivastava Oct 12 '18 at 10:14
Use `age_col = pd.to_numeric(age_col, errors='coerce')` – jezrael Oct 12 '18 at 10:22
Thanks jezrael, still unable t solve the problem. now i am getting new error "KeyError: 33" – Anand Srivastava Oct 12 '18 at 10:35
Not understand, `pd.to_numeric(age_col, errors='coerce').sum()` not working ? – jezrael Oct 12 '18 at 10:38

unable to get sum of values in a column of dataframe

0 Answers0