Adding Of Two pandas Series objects

Adding two pandas Series objects produces a new Series instance. The pandas example code applies mathematical addition between two Series instances by calling the function Series.add().

Series Binaryoperatorfunctions Updated 25 Aug 2019 2 min read

Overview

  • The pandas Series class is used for storing large amounts of one-dimensional data such as time-series data and applying mathematical and analytical operations on it.
  • Two pandas.Series instances can be added together to produce a new Series instance.
  • Calling add() function on a Series instance by passing another Series instance as the parameter, produces a new Series instance which has the elements of both the series added up.
  • In the same way to add elements of two pandas DataFrame instances, the DataFrame.add() method can be used.

Example

python
# Example python program to add two pandas

# Series instances

import pandas as pds

# Dataset1 as a python list

dataSet1 = [1,3,5,7,9];

# Dataset2 as a python list

dataSet2 = [2,4,6,8,10];

# Load datasets into pandas.Series instances

series1 = pds.Series(dataSet1);

series2 = pds.Series(dataSet2);

# Apply binary addition between two pandas.Series instances

series3 = series1+series2;

print("pandas Series1:");

print(series1);

print("pandas Series2:");

print(series2);

# Result of applying binary addition between two pandas.Series instances

print("Result of adding two Series instances:");

print(series3);

Output

Output
pandas Series1:

0    1

1    3

2    5

3    7

4    9

dtype: int64

pandas Series2:

0     2

1     4

2     6

3     8

4    10

dtype: int64

Result of adding two Series instances:

0     3

1     7

2    11

3    15

4    19

dtype: int64

Example – Adding two pandas.Series instances with None values repalced

This Python example code adds two pandas.Series instances where they have some of their elements as None. The fill_value parameter of the add() function replaces any occurence of None with a specified value.

python
# Example Python Program to add two pandas.Series instances

# where the instances have few None values

import pandas as pds

ser1 = pds.Series([10,20,30,None,50]);

ser2 = pds.Series([10,None,30,40,None]);

ser3 = ser1.add(ser2, fill_value=10);

print("Series1 + Series2:(With None values repalced by 10)")

print(ser3);

Output

Output
Series1 + Series2:(With None values repalced by 10)

0    20.0

1    30.0

2    60.0

3    50.0

4    60.0

dtype: float64

Example

The Series.add() method not only adds elements from two pandas.Series instances, it also adds elements from any Python sequence such as list with the elements of a pandas.Series instance.

python
# Example Python Program to a pandas.Series and

# a Python Sequence

import pandas as pds

# A list of probabilities

probalities1 = [0.2, 0.01, 0.7, 0.3, 0.2];

# A pandas Series with probability values

probalities2 = pds.Series([0.15, 0.02, 0.15, 0.1, 0.3 ]);

# Add a list and a Series

resultantSeries = probalities2.add(probalities1);

print("Contents of the Python list:");

print(probalities1);

print("Contents of the pandas Series:");

print(probalities2);

print("Result of the addition:");

print(resultantSeries);

Output

Output
Contents of the Python list:

[0.2, 0.01, 0.7, 0.3, 0.2]

Contents of the pandas Series:

0    0.15

1    0.02

2    0.15

3    0.10

4    0.30

dtype: float64

Result of the addition:

0    0.35

1    0.03

2    0.85

3    0.40

4    0.50

dtype: float64