A Guide to R for Excel Users

Many of the clients I work with are coming from Excel. When I teach them R, I try to relate new information to things they are already familiar with. In that spirit, I’ve put together a short video that shows some key functions (select, mutate, filter, summarize, group_by, and arrange) from the dplyr package in R. If you’ve ever wondered, say, what the equivalent of the filter function would be in Excel, I’ve got you covered!
A rendered version of the RMarkdown document used in the video is below (a version with slides is here).
Pipes
One thing not covered in this video is the pipe (for more, see this post). Written as %>% it enables you to chain together a series of functions on a data frame. So, for example, you
- Filter to only include those who are 150 centimeters or taller, then
- Create a group for males and a group for females, then
- Calculate the mean height.
All steps can be done in a single chunk of code, tied together with pipes. If you’re coming from Excel, you might think of it as writing out a series of points and clicks that do a set of things on your original dataset.

Ready to Learn More?
Interested in learning more? The six functions discussed here, the pipe, and much more are covered in depth in my Fundamentals of R course.
[…] document in R. Many people come to R from Excel so having a set of R to Excel equivalents (also see this post on a similar topic) is […]