eq() Function Of Pandas DataFrame Class

The eq() function returns a pandas DataFrame instance with the equality results of two DataFrames. The example python program compares two DataFrame instances of floating point values for equality and prints the results onto the console.

Dataframe Binaryoperatorfunctions Updated 24 Jul 2019 1 min read

Overview

  • The eq() method of DataFrame class implements the binary operation "Logical Equal To" also called as the "Equality" operation.
  • The eq() method when invoked on a DataFrame instance, checks each element of the instance with the element of another DataFrame instance for equality.
  • The results of the equality tests are returned in a separate DataFrame instance whose elements are Boolean values. A value True indicates the corresponding DataFrame elements were equal in the value. A value False indicates the elements were unequal.

Example

python
import pandas as pd

# Floating point data

floats1 = [(1.1, 1.2, 1.3),

           (0.1, 0.2, 0.3),

           (2.1, 2.2, 2.3)];

floats2 = [(0.50, 2.50, 1.0),

           (0.1, 0.2, 0.4),

           (1.5, 2.5, 3.35)];

# Floating point data into DataFrames

dataFrame1      = pd.DataFrame(data=floats1);

dataFrame2      = pd.DataFrame(data=floats2);

equalityResults = dataFrame1.eq(dataFrame2);

# Print the pandas DataFrames and the result of Equality Test

print("Contents of DataFrame1:");

print(dataFrame1);

print("Contents of DataFrame2:");

print(dataFrame2);

print("DataFrame1.eq(DataFrame2):");

print(equalityResults);

Output

Output
Contents of DataFrame1:

     0    1    2

0  1.1  1.2  1.3

1  0.1  0.2  0.3

2  2.1  2.2  2.3

Contents of DataFrame2:

     0    1     2

0  0.5  2.5  1.00

1  0.1  0.2  0.40

2  1.5  2.5  3.35

DataFrame1.eq(DataFrame2):

       0      1      2

0  False  False  False

1   True   True  False

2  False  False  False