Comparison of Excel VLOOKUP and R left_join
Whenever I hear that someone spends a bunch of time using VLOOKUP to connect two data sets, I explain that there's a better way. This video shows how by importing directly in from Excel and exporting back to Excel using R. This way, your end user can still live in Excel, while you enjoy the speed and reproducibility of a R.
Code and files can be found here:
https://github.com/bradweiner/vlookup...