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

 

 


Copyright 2022 © pythontic.com