I have two dataframes,
ID Key 1 A 2 B 3 C 4 D
ID Key 1 D 2 C 3 B 4 E
Now, if the key in the df1 is found in df2 then the new column will have a value found else not found
the df1 with the output dataframe becomes,
ID Key Result 1 A Not Found 2 B Found 3 C Found 4 D Found
How can we do this using Pandas ? It's not a join/concat/merge by ID. Kindly help me with this.