Question

Draw two tables for multiplication similar to the 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

Multiplication without replacing missing values:

When missing values (NaN) are present, any multiplication involving them results directly in NaN.

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

Multiplication after replacing missing values with 0:

In this table, any completely missing value (blank space) is replaced with 0 before the multiplication takes place.

index	value from seriesA	value from seriesB	seriesA + seriesB
a	1	−10	−10.0
b	2	0	0.0
c	3	−50	−150.0
d	4	0	0.0
e	5	100	500.0
y	0	20	0.0
z	0	10	0.0