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