Adding Of Two pandas Series objects

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:

# 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:

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.

# 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:

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.

# 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:

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

Adding Of Two Pandas Series Objects

Overview:

Example:

Output:

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

Output:

Example:

Output: