Question

Draw two tables for subtraction 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 1000.

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

Subtraction without replacing missing values:

index	value from seriesA	value from seriesB	seriesA + seriesB
a	1	−10	11.0 (1 − (−10))
b	2		NaN
c	3	−50	53.0
d	4		NaN
e	5	100	−95.0 (5 − 100)
y		20	NaN
z		10	NaN

Subtraction after replacing missing values with 1000:

index	value from seriesA	value from seriesB	seriesA + seriesB
a	1	−10	−11.0 (1 − (−10))
b	2	1000	−998.0 (2 − 1000)
c	3	−50	53.0 (3 − (−50))
d	4	1000	−996.0 (4 − 1000)
e	5	100	−95.0 (5 − 100)
y	1000	20	980.0 (1000 − 20)
z	1000	10	990.0 (1000 − 10)