1

When matching two dfs (say A and B) on values of a column called id_number, I am trying to identify rows in A, which cannot find a matching id number in B, e.g. A is like,

id_number    name
1            a
2            b
3            c

B is like,

id_number    year
1            2007
2            2010
4            2008

I want to create a boolean column called has_b in A, result in,

id_number    name    has_b
1            a       True
2            b       True
3            c       False

I am wondering how to achieve the above dataframe.

daiyue
  • 7,196
  • 25
  • 82
  • 149

0 Answers0