Mar-02-2025, 01:51 PM
Yeah, that's all pandas is doing: checking things in lists. Each row or column is a list, Just, you can't see behind the scenes, so you don't see that, then it seems like arcane magic.
I would point out that you do not have a column "Amount", you posted "Amt", so you will get an error there, like I did first time around.
Still like this one-liner:
I would point out that you do not have a column "Amount", you posted "Amt", so you will get an error there, like I did first time around.
Quote:Columns:
"Date", "Acct", "Type", "Amt", "Category", "Note", "Extra"
Still like this one-liner:
res = df1[~df1.isin(df2)].dropna()