For day 5, I had to create a function, and I’m writing this up, because it’s an example of a non-equi join between two tables.
In this particular sitation, there are are no common columns between the two tables, so my usual
data.tablehack of copying the columns of interest, renaming them
join_col, and then keying them both does not work.
Click through for a working solution.