Merging large datasets with a data.table
In previous recipes, we demonstrated how to manipulate and aggregate data with a
data.table. In addition to performing data manipulation on a single table, we often need to import additional features or correlate data from other data sources. Therefore, we can join two or more tables into one. In this recipe, we introduce some methods that we can use to merge two
Ensure that you completed the Enhancing a data.frame with a data.table recipe to load
purchase_order.tab as both
data.table into your R environment.
How to do it…
Perform the following steps to merge two
- First, we generate a
product.dtdata table by calculating the number of ...