Adding Of Two Data Frames

Overview:

  • The Python library pandas, offers several methods to handle two-dimensional data through the class DataFrame.
  • Two DataFrames can be added by using the add() method of pandas DataFrame class.
  • Calling add() method is similar to calling the operator +. However, the add() method can be passed a fill value, which will be used for NaN values in the DataFrame.

 

Example:

import pandas as pd

 

dataSet1 = [(10, 20, 30),

            (40, 50, 60),

            (70, 80, 90)];

             

dataFrame1 = pd.DataFrame(data=dataSet1)

 

dataSet2 = [(5, 15, 25),

            (35, 45, 55),

            (65, 75, 85)];

dataFrame2 = pd.DataFrame(data=dataSet2)

 

print("DataFrame1:");

print(dataFrame1);

 

print("DataFrame2:");

print(dataFrame2);

 

result = dataFrame1.add(dataFrame2);

print("Result of adding two pandas dataframes:");

print(result)

 

Output:

 

DataFrame1:

    0   1   2

0  10  20  30

1  40  50  60

2  70  80  90

DataFrame2:

    0   1   2

0   5  15  25

1  35  45  55

2  65  75  85

Result of adding two pandas dataframes:

     0    1    2

0   15   35   55

1   75   95  115

2  135  155  175

 

 


Copyright 2023 © pythontic.com