Assignment by Reference in R's Data Table: A Common Pitfall to Avoid When Aggregating Data

Joining Tables with Recent Date for Each Row Then Weighted Averaging