Skip to content

R for Excel Users

Menu
  • Home
  • Book

Category: Mimmic Excel Features

Mimmic Excel Features

Find nth largest or smallest in a group

You want to identify the nth largest or smallest item in a group using R. For example, to filter out the two rows in the table below: Any time there …

Mimmic Excel Features

Calculate percent of column in R

You want to calculate percent of column in R as shown in this example, or as you would in a PivotTable: Here are two ways: (1) using Base R, (2) …

Mimmic Excel Features

How to do MID, RIGHT an LEFT in R

MID(), LEFT() and RIGHT() make it easy to extract parts of strings in Excel. Let’s see how we apply those in R. Using substr() Let’s start with a simple example …

Mimmic Excel Features

Excel Formulas and R Functions

Below is a short list of basic, commonly-used Excel formulas and their R counterparts. The R functions are part of Base R, in that they do no require third-party packages. …

Mimmic Excel Features

Column to Text in R

This is not an Excel feature, although it should be! Often times we have a list of things in a column that needs to be combined into, say, a comma-delimited …

Mimmic Excel Features

How to do VLOOKUP in R

VLOOKUP is usually the first magical formula people learn when learning Excel. The magic never goes away. So let’s see how to do a VLOOKUP in R. Situation Let’s say …

Mimmic Excel Features

How to Make a PivotTable in R

The Excel PivotTable is plain awesome. In this post I will show you how to make a PivotTable in R (kind of). We will use two popular libraries, dplyr and …

Mimmic Excel Features

Excel vs R: When to use what

Believe it or not, Excel is still my go-to analysis tool a lot of times, because it’s great at what it does.  I’m a shortcut fiend, so I can do …

Excel Stuff Done in R

  • Find nth largest or smallest in a group
  • Calculate percent of column in R
  • How to do MID, RIGHT an LEFT in R
  • Excel Formulas and R Functions
  • Column to Text in R

General R Stuff

  • Calculate percent of row in R
  • How to Remove Dollar Sign in R (and other currency symbols)
  • Looping: lapply, sapply, mapply & apply
  • Delete Data Frame in R
  • R Vectors: A Must-Learn

Thought Starters & Analysis

  • Learning Analytics? Crawl Before you Walk
  • Time Series Clustering of Baby Names
  • Names at a Party – Bootstrap Sampling with R
  • The growing number of baby names – using dplyr
Copyright © 2021 R for Excel Users – OnePress theme by FameThemes