0

I am trying to check if any values within df1 in the Value column match to df2 [which will be a list]. Below will show you the structure of both.

My current DataFrames: df1:

ID Value
1256 AMD left out early in the morning
1546 Jessica will need to be picked up from ORD
7877 (TBA)
3794 BLT might be crowded
8946 iPod was found at (SMH)
4568 ATL
5669 SAN

df2:[a list]

AIRPORTS
AMD
TBA
BLT
SMH
ATL

desired output:

ID Value Match
1256 AMD left out early in the morning True
1546 Jessica will need to be picked up from ORD False
7877 (TBA) True
3794 BLT might be crowded True
8946 iPod was found at (SMH) True
4568 ATL True
5669 SAN False
Michael Butscher
  • 10,028
  • 4
  • 24
  • 25
PickleRick
  • 61
  • 5

0 Answers0