[Python] Comapre two DF with different lengths based on same column name

I have 2 Dataframe of different lengths (number of rows and columns are different )but having some same column names I want to filter out rows of DF1 where column value of Dataframe 1 is present in column value of Dataframe 2

eg: DF1:



DF2:



Result DF:



I tried using df.loc but it is not working as the lengths of the dataframes are different. If Itow in DF1 is present in DF2 then it should filter out that row from DF1.

res = x.loc[(x["_iTOW"]) == (act_3d_fixes_spoof["_iTOW"])]

Continue reading...