Python Pandas – Check if any specific column of two DataFrames are equal or not

To check if any specific column of two DataFrames are equal or not, use the equals() method. This method compares both the values and the structure of the columns, returning True if they are identical.

Creating Sample DataFrames

Let us first create DataFrame1 with two columns ?

import pandas as pd

dataFrame1 = pd.DataFrame(
    {
        "Car": ['BMW', 'Lexus', 'Audi', 'Mustang', 'Bentley', 'Jaguar'],
        "Units": [100, 150, 110, 80, 110, 90]
    }
)
print("DataFrame1:")
print(dataFrame1)

DataFrame1:
       Car  Units
0      BMW    100
1    Lexus    150
2     Audi    110
3  Mustang     80
4  Bentley    110
5   Jaguar     90

Create DataFrame2 with two columns ?

import pandas as pd

dataFrame2 = pd.DataFrame(
    {
        "Car": ['BMW', 'Lexus', 'Audi', 'Mustang', 'Mercedes', 'Jaguar'],
        "Units": [100, 150, 110, 80, 110, 90]
    }
)
print("DataFrame2:")
print(dataFrame2)

DataFrame2:
       Car  Units
0      BMW    100
1    Lexus    150
2     Audi    110
3  Mustang     80
4 Mercedes    110
5   Jaguar     90

Checking Column Equality

Check for the equality of a specific column Units ?

import pandas as pd

# Create DataFrames
dataFrame1 = pd.DataFrame(
    {
        "Car": ['BMW', 'Lexus', 'Audi', 'Mustang', 'Bentley', 'Jaguar'],
        "Units": [100, 150, 110, 80, 110, 90]
    }
)

dataFrame2 = pd.DataFrame(
    {
        "Car": ['BMW', 'Lexus', 'Audi', 'Mustang', 'Mercedes', 'Jaguar'],
        "Units": [100, 150, 110, 80, 110, 90]
    }
)

# Check for equality of entire DataFrames
print("Are both DataFrames equal?", dataFrame1.equals(dataFrame2))

# Check for specific column Units equality
print("Are both Units columns equal?", dataFrame2['Units'].equals(dataFrame1['Units']))

# Check for specific column Car equality
print("Are both Car columns equal?", dataFrame2['Car'].equals(dataFrame1['Car']))

Are both DataFrames equal? False
Are both Units columns equal? True
Are both Car columns equal? False

Key Points

• The equals() method checks both values and order
• It returns True only if columns are identical in every aspect
• Different from == operator which returns element-wise comparison
• Useful for validation and data integrity checks

Conclusion

Use the equals() method to check if specific columns of two DataFrames are identical. This method compares both values and structure, making it ideal for data validation tasks.