join

data.table - non-equi-joins

Hi, in this post we are going to explore non-equi-joins using the data.table package in R. non-equi-joins can be utilized, when you want to join two tables based on inequalities. We will use the flights data set, which we will download from github using the fread function. From this data set I am going to generate a second table which will be used as a look up table. More on this later.