Series arithmetic and alignment in Data Analysis Python - Step-by-Step Execution

Concept Flow - Series arithmetic and alignment

Create Series A

↓

Create Series B

↓

Align indexes of A and B

↓

Perform arithmetic operation element-wise

↓

Result Series with combined index and NaN where no match

↓

Optional: Fill NaN or drop

↓

Final aligned arithmetic result

We create two Series, align their indexes automatically, then do element-wise arithmetic. Missing matches become NaN.

Execution Sample

Data Analysis Python

import pandas as pd
s1 = pd.Series([10, 20, 30], index=['a', 'b', 'c'])
s2 = pd.Series([1, 2, 3], index=['b', 'c', 'd'])
s3 = s1 + s2
print(s3)

Add two Series with different indexes; pandas aligns by index and sums matching labels.

Execution Table

Step	s1 Value	s1 Index	s2 Value	s2 Index	Aligned Index	Operation	Result Value
1	10	a	NaN	a (missing)	a	10 + NaN	NaN
2	20	b	1	b	b	20 + 1	21
3	30	c	2	c	c	30 + 2	32
4	NaN	d (missing)	3	d	d	NaN + 3	NaN
5	Final Result						a: NaN, b: 21, c: 32, d: NaN

💡 All indexes aligned; arithmetic done element-wise; NaN where no matching index.

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4	Final
s1	[10,20,30]	{a:10,b:20,c:30}	{a:10,b:20,c:30}	{a:10,b:20,c:30}	{a:10,b:20,c:30}	{a:10,b:20,c:30}
s2	[1,2,3]	{b:1,c:2,d:3}	{b:1,c:2,d:3}	{b:1,c:2,d:3}	{b:1,c:2,d:3}	{b:1,c:2,d:3}
s3	empty	{a:NaN}	{a:NaN,b:21}	{a:NaN,b:21,c:32}	{a:NaN,b:21,c:32,d:NaN}	{a:NaN,b:21,c:32,d:NaN}

Key Moments - 3 Insights

Why does the result have NaN for index 'a' and 'd'?

Because 'a' is only in s1 and 'd' only in s2, pandas aligns indexes and where one Series lacks a label, the result is NaN (see execution_table rows 1 and 4).

How does pandas know which elements to add together?

Pandas aligns Series by their index labels before arithmetic, so values with the same index label are added (see execution_table rows 2 and 3).

What happens if you want to replace NaN with zero after addition?

You can use the fillna(0) method on the result Series to replace NaN with 0, so missing matches count as zero.

Visual Quiz - 3 Questions

Look at the execution_table, what is the result value at step 3 for index 'c'?

A 30

B 32

C 2

D NaN

💡 Hint

Check the 'Result Value' column at step 3 in the execution_table.

At which step does the operation involve adding a value from s1 with a missing value from s2?

A Step 1

B Step 2

C Step 4

D Step 3

💡 Hint

Look for where s2 value is NaN in the execution_table.

If s2 had an additional index 'a' with value 5, how would the result at index 'a' change?

A It would become 5

B It would remain NaN

C It would become 15

D It would become 10

💡 Hint

Adding s1's 10 and s2's 5 at index 'a' sums to 15.

Concept Snapshot

Series arithmetic aligns indexes automatically.
Operations happen element-wise by matching labels.
Missing labels produce NaN in results.
Use fillna() to handle NaN if needed.
Supports +, -, *, / with alignment.

Full Transcript

This visual execution shows how pandas Series arithmetic works by aligning indexes before performing element-wise operations. Two Series s1 and s2 with different indexes are added. The process aligns their indexes: 'a', 'b', 'c', 'd'. For indexes present in both, values are added. For indexes missing in one Series, the result is NaN. The variable tracker shows s1 and s2 remain unchanged, while s3 builds up with results including NaN where no match exists. Key moments clarify why NaN appears and how alignment works. The quiz tests understanding of specific steps and effects of changing data. The snapshot summarizes the core rules of Series arithmetic and alignment.

Practice

1. What happens when you add two pandas Series with different labels using + operator?

easy

A. The result is a Series with all zeros

B. Values are added ignoring labels, just by position

C. An error is raised due to label mismatch

D. Values are added only where labels match; others become NaN

Solution

1. Step 1: Understand pandas Series label alignment

   When adding two Series, pandas aligns data by their labels (index) before performing arithmetic.

2. Step 2: Effect of label mismatch on addition

   If a label is missing in one Series, the result for that label is NaN because pandas cannot add missing data.

3. Final Answer:

   Values are added only where labels match; others become NaN -> Option D

4. Quick Check:

   Series addition aligns labels = Values are added only where labels match; others become NaN [OK]

Hint: Remember: pandas adds by matching labels, not positions [OK]

Common Mistakes:

• Assuming addition ignores labels and adds by position
• Expecting an error on label mismatch
• Thinking missing labels fill with zero automatically

2. Which of the following is the correct syntax to add two pandas Series s1 and s2 with label alignment, allowing specification of fill_value for missing labels?

easy

A. s1 + s2

B. s1 + s2.values

C. s1.add(s2)

D. s1.append(s2)

Solution

1. Step 1: Check syntax for adding Series with alignment and fill_value

   Using s1.add(s2) adds Series with label alignment and allows fill_value for missing labels.

2. Step 2: Compare other options

   s1 + s2 adds with alignment but no fill_value option. s1 + s2.values ignores labels (positional). s1.append(s2) concatenates.

3. Final Answer:

   s1.add(s2) -> Option C

4. Quick Check:

   Use .add() for aligned addition with fill_value [OK]

Hint: Use .add() method for safe label-aligned addition [OK]

Common Mistakes:

• Using + with raw values ignoring labels
• Confusing append with addition
• Not knowing .add() exists for Series

3. Given the code:

import pandas as pd
s1 = pd.Series([10, 20, 30], index=['a', 'b', 'c'])
s2 = pd.Series([1, 3, 3], index=['b', 'c', 'd'])
result = s1 + s2
print(result)

What is the output?

medium

A. a NaN
b 21.0
c 33.0
d NaN

B. a 10
b 22
c 33
d 3

C. a 10
b 21
c 33
d 3

D. a NaN
b 22.0
c 33.0
d NaN

Solution

1. Step 1: Align Series by labels

   s1 has 'a':10, 'b':20, 'c':30; s2 has 'b':1, 'c':3, 'd':3. Union index: 'a','b','c','d'.

2. Step 2: Add values where labels match, NaN otherwise

   'a': 10 + NaN = NaN, 'b':20+1=21.0, 'c':30+3=33.0, 'd': NaN + 3 = NaN. Floats due to NaN.

3. Final Answer:

   a NaN b 21.0 c 33.0 d NaN -> Option A

4. Quick Check:

   Series addition aligns labels, unmatched get NaN [OK]

Hint: Add Series and check labels; unmatched labels become NaN [OK]

Common Mistakes:

• Adding values by position ignoring labels
• Expecting no NaN for unmatched labels
• Misreading index labels and values

4. Consider the code:

import pandas as pd
s1 = pd.Series([5, 10], index=['x', 'y'])
s2 = pd.Series([2, 4, 6], index=['x', 'y', 'z'])
result = s1 + s2
print(result)

The result contains NaN. What is the problem and how to fix it to treat missing values as zero?

medium

A. No error; code runs fine

B. NaN due to different lengths; fix by using s1.add(s2, fill_value=0)

C. Error because + cannot add Series; use concat instead

D. Error due to missing index in s1; fix by reindexing s1 to s2's index

Solution

1. Step 1: Check the code execution

   The code runs but produces NaN for 'z' (missing in s1). Alignment by labels causes NaN for unmatched.

2. Step 2: Fix with fill_value

   s1.add(s2, fill_value=0) fills missing labels with 0: 'x':7, 'y':14, 'z':6.

3. Final Answer:

   NaN due to different lengths; fix by using s1.add(s2, fill_value=0) -> Option B

4. Quick Check:

   Use .add() with fill_value to avoid NaN [OK]

Hint: Use .add(fill_value=0) to handle missing labels safely [OK]

Common Mistakes:

• Thinking + raises error on length mismatch
• Using concat instead of arithmetic
• Ignoring missing labels causing NaN

5. You have two Series representing sales in two stores:

store1 = pd.Series([100, 200, 300], index=['apple', 'banana', 'orange'])
store2 = pd.Series([50, 150, 100], index=['banana', 'orange', 'grape'])

How do you create a Series showing total sales per fruit, treating missing fruits as zero?

hard

A. store1.add(store2, fill_value=0)

B. store1 + store2

C. store1.append(store2).sum()

D. store1.combine(store2, lambda x, y: x + y)

Solution

1. Step 1: Understand the problem

   We want to add sales per fruit, but some fruits are missing in one store's Series.

2. Step 2: Use addition with fill_value=0

   Using store1.add(store2, fill_value=0) adds values label-wise, treating missing labels as zero, so no NaN appears.

3. Final Answer:

   store1.add(store2, fill_value=0) -> Option A

4. Quick Check:

   Add Series with fill_value=0 to handle missing labels [OK]

Hint: Use .add(fill_value=0) to sum with missing labels as zero [OK]

Common Mistakes:

• Using + causing NaN for missing labels
• Using append and sum incorrectly
• Using combine without fill_value causing NaN