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: int64Example – 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: float64Example
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