Subtracting a pandas DataFrame from another DataFrame

sub() function of pandas DataFrame class subtracts one DataFrame object from another DataFrame object. The Python example constructs two DataFrames and subtracts one from the another.The resultant DataFrame is printed onto the console.

Dataframe Binaryoperatorfunctions Updated 6 Jun 2019 1 min read

Overview

  • Python pandas library provides multitude of functions to work on two dimensioanl Data through the DataFrame class.
  • The sub() method of pandas DataFrame subtracts the elements of one DataFrame from the elements of another DataFrame.
  • Invoking sub() method on a DataFrame object is equivalent to calling the binary subtraction operator(-).
  • The sub() method supports passing a parameter for missing values(np.nan, None).

Example

python
import pandas as pd

# Create Data

data1 = [(2, 4, 6, 8),

         (1, 3, 5, 7),

         (5, 0, 0, 9)];

data2 = [(1, 1, 0 , 1),

         (1, 0, 1 , 1),

         (0, 1, 1 , 0)];

# Construct DataFrame1

dataFrame1 = pd.DataFrame(data=data1);

print("DataFrame1:");

print(dataFrame1);

# Construct DataFrame2

dataFrame2 = pd.DataFrame(data=data2);

print("DataFrame2:");

print(dataFrame2);

# Subtracting DataFrame2 from DataFrame1

subtractionResults = dataFrame1 - dataFrame2;

print("Result of subtracting dataFrame1 from dataFrame2:");

print(subtractionResults);

Output

Output
DataFrame1:

   0  1  2  3

0  2  4  6  8

1  1  3  5  7

2  5  0  0  9

DataFrame2:

   0  1  2  3

0  1  1  0  1

1  1  0  1  1

2  0  1  1  0

Result of subtracting dataFrame1 from dataFrame2:

   0  1  2  3

0  1  3  6  7

1  0  3  4  6

2  5 -1 -1  9

##