VLOOKUP-style using dplyr by Fiona MacNeill is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Based on a work at https://dplyr.tidyverse.org/.
Read the tutorial here: ../master/dplyrtutorial.md
OR download the PDF version of the tutorial here: ../master/dplyr_vlookup.pdf
Download tutorial materials, including the R Markdown file and simulated sample data here.
Information to verify the zip file -
md5: 5f3e5667adad7540eac13dad836b9e1c
sha1: a5a2ba362cd20356ddf221a0e8ac07700870d30f
How to check md5 and sha1 on a Mac (YouTube Video):
You have been sent a text file, or you have copy and pasted from a Microsoft Word document into a new text file. The text file contains a list of names and you need to match these names up with usernames so that you can actually do something useful with this information. You also have a Excel spreadsheet which you have exported from the VLE with a longer list of names, including the username column. You need to match the names in your text file to the names in the Excel and return only the relevant names and the username column. You could use VLOOKUP in Microsoft Excel, but you decide to live a little and use RStudio and some packages instead. Plus VLOOKUP is ever-so-fussy, can we do better?