Create dataframe from the unique data of two dataframes

[Calab]

Try this, seems to work on the scant data you provided:

...

Output:
res
         Date   Acct      Type   Amt Category Note            Extra
1  2025-02-28  98765  Purchase  2.33                Coffee on debit

Sorry for the limited test data. I didn't want to overfill my post.

That appears to work, but it appears to drop any row where a single column is duplicated. What I was looking for was if all the columns were duplicated, except for the "Category" and "Note" column.

I did not explain it very well in my post. I probably confused myself while writing the post.

It looks like I made a small mistake: "...there is not a match on the "Date", "Acct", "Type", "Amount" or "Extra" columns ...". That "or" should have been an "and".