Question

Draw two tables for division similar to tables showing the changes in the series elements and corresponding output without replacing the missing values, and after replacing the missing values with 0.

index	value from seriesA	value from seriesB	seriesA + seriesB
a	1	−10	−9.0
b	2		NaN
c	3	−50	−47.0
d	4		NaN
e	5	100	105.00
y		20	NaN
z		10	NaN

 

index	value from seriesA	value from seriesB	seriesA + seriesB
a	1	−10	−9.0
b	2	0	2.0
c	3	−50	−47.0
d	4	000	4.0
e	5	100	105.00
y	0	20	20.0
z	0	10	10.0

Answer 1

Division of Series without replacing missing values:

When missing values (NaN) are present, any division involving them automatically results in NaN.

index	value from seriesA	value from seriesB	seriesA + seriesB
a	1	−10	−0.1
b	2		NaN
c	3	−50	−0.06
d	4		NaN
e	5	100	0.05
y		20	NaN
z		10	NaN

Division of Series after replacing missing values with 0:

In this table, missing values are replaced with 0 before the division takes place.

index	value from seriesA	value from seriesB	seriesA + seriesB
a	1	−10	−0.1
b	2	0	inf
c	3	−50	−0.06
d	4	0	inf
e	5	100	0.05
y	0	20	0.0
z	0	10	0.0