You can use the following library: https://github.com/SimpleSimpler/data_fingerprint
This library will tell you exactly where are differences between two dataframes, here is an example:
import polars as pl
from data_fingerprint.src.utils import get_dataframe
from data_fingerprint.src.comparator import get_data_report
from data_fingerprint.src.models import DataReport
# ...
# Generate a data report comparing the two datasets
report: DataReport = get_data_report(df1, df2, "df_1", "df_2")
# print out the differences
print(get_dataframe(report))
You can even try it in streamlit: https://datafingerprinttry.streamlit.app