I have two DFs having applicationnumber and APPLICATIONNUMBER key. I want to select those rows, where this key does NOT match.
I tried:
df.loc[df['applicationnumber'] not in df_rdm['APPLICATIONNUMBER'].squeeze()]
Helo would be appreciated.
Asked
Active
Viewed 14 times
0
Stanislav Jirak
- 725
- 1
- 7
- 22
-
1Do you need `df[~df['applicationnumber'].isin(df_rdm['APPLICATIONNUMBER'])]` ? – jezrael Apr 28 '22 at 07:39
-
1Rado sa stalo ;) – jezrael Apr 28 '22 at 07:42