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 |