Skip to content

How to use the dplyr package to get a similar effect to VLOOKUP in Microsoft Excel. A tutorial featuring R markdown for RStudio and simulated sample data.

License

Notifications You must be signed in to change notification settings

FionaMacNeill/dplyr_vlookup

Repository files navigation

VLOOKUP-style using dplyr

Creative Commons Licence
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/.

Gangnam-style and @pusheen cat via GIPHY

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):

Still from video

Why might you want to do this...

Learning Technologies Scenario:

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?

About

How to use the dplyr package to get a similar effect to VLOOKUP in Microsoft Excel. A tutorial featuring R markdown for RStudio and simulated sample data.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published