Skip to content

R for Excel Users

Menu
  • Home
  • Book

Blog

The blog posts below assume you are already up and running in R. Check out the book!

1. Excel Stuff Done in R

  • Calculate percent of column in R
  • Column to Text in R
  • Excel Formulas and R Functions
  • Excel vs R: When to use what
  • Find nth largest or smallest in a group
  • How to do MID, RIGHT an LEFT in R
  • How to do VLOOKUP in R
  • How to Make a PivotTable in R

2. General R Stuff

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

3. Thought Starters & Analysis

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