Why it says NaN when I'm trying to sum rows using Python Pandas?

Question

Title Netquantity Bases Chambers
x          2              4
y                 5

To get the total of bases chambers, I've used

concat_list.loc['Total'] = concat_list[['Bases','Chambers']].sum()

However, the output was

Title Netquantity Bases Chambers

x          2              4
y                 5        
Total    NaN    NaN     NaN

Could you help me to debug this issue? Some of the numbers are empty. I tried to

concat_list = concat_list.fillna(0)

But still didn't work.

jezrael · Answer 1 · 2021-12-03T07:46:57.327

0

Here is problem there are values mixed strings with numeric or all strings, first tray convert to floats:

concat_list.loc['Total'] = concat_list[['Bases','Chambers']].astype(float).sum()

If not working, try replace not parseable values to missing values by to_numeric per all columns, so use DataFrame.apply:

concat_list.loc['Total'] = concat_list[['Bases','Chambers']].apply(pd.to_numeric, errors='coerce').sum()

edited Dec 03 '21 at 07:46

answered Dec 03 '21 at 07:15

jezrael

Maybe duplicate question of: https://stackoverflow.com/questions/12229902/sum-a-list-which-contains-none-using-python – Reza Akraminejad Dec 03 '21 at 07:27
@Hamed_gibago - I think not. – jezrael Dec 03 '21 at 07:27
@jazrael still not working. The first solution didnt work. Output was ValueError: could not convert string to float: '' But the second one worked. Could you explain the line .apply briefly? – Samuel Saerang Dec 03 '21 at 07:38
@SamuelSaerang - Second solution working? – jezrael Dec 03 '21 at 07:39
1

@jezrael it's working could you explain briefly the .apply logic? – Samuel Saerang Dec 03 '21 at 07:41

1 Answers1