bowie brewster

About bowie brewster

i import pandas as pd

# Assuming df1 and df2 are your two dataframes
# Merge on columns A and B, and identify which entries are equal
merged_df = pd.merge(df1, df2, on=['A', 'B'], how='outer', indicator=True)

# Rows with entries in both dataframes are equal
equal_rows = merged_df[merged_df['_merge'] == 'both']

# Rows present in df1 but not in df2
rows_missing_in_df2 = merged_df[merged_df['_merge'] == 'left_only']

# Rows present in df2 but not in df1
rows_missing_in_df1 = merged_df[merged_df['_merge'] == 'right_only']

# Rows with different entries
different_entries = merged_df[merged_df['_merge'] == 'both'][df1.columns].ne(merged_df[merged_df['_merge'] == 'both'][df2.columns]).any(axis=1)

# Display the results
print("Equal Entries:")
print(equal_rows)

print("\nRows Missing in df2:")
print(rows_missing_in_df2)

print("\nRows Missing in df1:")
print(rows_missing_in_df1)

print("\nRows with Different Entries:")
print(merged_df[merged_df['_merge'] == 'both'][different_entries])