Skip to content

R for Excel Users

Menu
  • Home
  • Book

Tag: substr

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 …

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