I use dplyr’s anti_join() for this type of task, never merge(). If you want to use data.table bracket syntax, use this code to see all the rows in home_values_dt that don’t have a match in pop ...