I have 2 pandas Series, like this
bananas 3.0
apples 2.0
avocados 4.0
bananas 2.0
apples 5.0
pineapple 1.0
If I just sum them, it returns this:
apples 7.0
avocados NaN
bananas 5.0
pineapple NaN
but what I want is
apples 7.0
avocados 4.0
bananas 5.0
pineapple 1.0