List of elements in join table without match

Question

While executing the left outer join, how do I obtain the elements from the right table that didn't find an equivalent in the left table? 

Answer 1

After performing the left_join in R programming, we cannot find out what wasn't matched. But you can use anti_join to find what doesn't match. Refer to the below code:

full_join(band_members, band_instruments)

# Joining, by = "name"

# # A tibble: 4 x 3

#   name  band    plays 

#   <chr> <chr>   <chr> 

# 1 Mick  Stones  <NA>  

# 2 John  Beatles guitar

# 3 Paul  Beatles bass  

# 4 Keith <NA>    guitar