Pandas DataFrame radd() Method

In this tutorial, we will discuss and learn the Python pandas DataFrame.radd() method. This method is used to get the addition of the dataframe and other, element-wise. It returns a DataFrame with the result of the addition operation in reverse.

The DataFrame.radd() method's syntax is shown below.

Syntax

DataFrame.radd(other, axis='columns', level=None, fill_value=None)

Parameters

other: It can be a scalar, sequence, Series, or DataFrame. It can be a single or multiple element data structure, or list-like object.

axis: It represents index or column axis, '0' for index and '1' for the column. When the axis=0, function applied over the index axis and when the axis=1 function applied over the column axis. For the input Series , axis to match Series index on.

level: It represents an int or label. It broadcasts across a level, matching Index values on the passed MultiIndex level.

fill_value: It represents the float or None, the default value is None. It fills the existing missing or null values, and any new element needed for successful DataFrame alignment, with this value before computation. If data in both corresponding DataFrame locations is missing the result will be missing.

Example 1: Adding the DataFrame by using the DataFrame.radd() Method

Here, we are adding the DataFrame with a scalar using the DataFrame.mul() method that returns a DataFrame that consists of the output of the reverse addition operation. See the example below.

#importing pandas as pd
import pandas as pd
#creating DataFrame
df = pd.DataFrame({'a': [2,5,7],'b': [1,2,3],'c': [4,5,7]})
print("---------The DataFrame is------")
print(df)
print("----------------------------")
print(df.radd(2))

---------The DataFrame is------
a b c
0 2 1 4
1 5 2 5
2 7 3 7
----------------------------
a b c
0 4 3 6
1 7 4 7
2 9 5 9

Example 2: Adding the DataFrame by using the DataFrame.radd() Method

Here, we are Adding the DataFrame with the other DataFrame using the DataFrame.radd() method that returns a DataFrame that consists of the output of the reverse addition operation. See the example below.

#importing pandas as pd
import pandas as pd
#creating DataFrame
df1 = pd.DataFrame({'a': [1,5,6],'b': [4,6,5],'c': [2,8,7]})
df2 = pd.DataFrame({'a': [2,1,1],'b': [1,5,8],'c': [7,5,6]})
print("------------The result is-----------")
print(df1.radd(df2))

------------The result is-----------
a b c
0 3 5 9
1 6 11 13
2 7 13 13

Example 3: Adding the DataFrame by using the DataFrame.radd() Method

This example is similar to the previous one. If the two DataFrames are not aligned then the resultant output consisting of the NaN values. See the below example.

#importing pandas as pd
import pandas as pd
#creating DataFrame
df1 = pd.DataFrame({'a': [1,5,6],'b': [4,6,5],'c': [2,8,7]})
df2 = pd.DataFrame({'a': [2,1,1],'b': [1,5,8]})
print("------------The result is-----------")
print(df1.radd(df2))

------------The result is-----------
a b c
0 3 5 NaN
1 6 11 NaN
2 7 13 NaN

Example 4: Adding the DataFrame by using the DataFrame.radd() Method

Here, in this example, we will fill any missing values by passing the fill_value=2 parameter in the DataFrame.radd() method. See the below example.

#importing pandas as pd
import pandas as pd
#creating DataFrame
df1 = pd.DataFrame({'a': [None,2,6],'b': [2,1,4],'c': [2,1,0]})
df2 = pd.DataFrame({'a': [1,1,2],'b': [None,5,0]})
print("------------The result is-----------")
print(df1.radd(df2,fill_value=2))

------------The result is-----------
a b c
0 3.0 4.0 4.0
1 3.0 6.0 3.0
2 8.0 4.0 2.0

Conclusion

In this tutorial, we learned the Python pandas DataFrame.radd() method. We learned syntax, parameters and solved examples by applying this function on the DataFrame and understood the method.