EXCEL2R

Learning R for Excel Users

Posted on: October 2, 2017 Posted by: Guy Manova Comments: 0

Remove duplicates in R

Removing duplicates in R In this tutorial we’ll see how to dedupe your data set – we’ll remove duplicates in R and compare it to Excel you can follow the step by step code below or download the R file from github:   # pre-session options rm(list = ls()) # …

Posted on: September 30, 2017 Posted by: Guy Manova Comments: 0

Pivot table value filters and label filters in R

R pivot tables filtering – learn how to create value filters and label filters in R In this tutorial we’ll see how to replicate excel pivot tables value and label filters, by creating value filters and label filters in R and distinguish between the differences also using sql’s “where” and …

Posted on: September 29, 2017 Posted by: Guy Manova Comments: 0

Pivot tables in R – pivoting rows to columns

Pivoting rows to columns – How to pivot a categorical attribute column into columns in R in this short tutorial we’ll see how¬†pivot rows to columns in R – replicating moving a categorical attribute from a pivot table row to a pivot table column (as you would do it in …

Posted on: September 28, 2017 Posted by: Guy Manova Comments: 0

Pivot tables in R – calculated field (or measure)

How to create calculated fields in R pivot tables In this tutorial, we’ll see how you can replicate an Excel pivot table calculated field (or calculated measure depending on your version) or aggregate SQL and create a calculated field in R, using the dplyr package. follow step by step below …

Posted on: September 28, 2017 Posted by: Guy Manova Comments: 0

Pivot Tables in R – Basic Pivot table, columns and metrics

Creating basic pivot tables in R with different metrics (measures) follow the step by step below or download the R file and load into R studio from github to create basic pivot tables in R: in this tutorial we’ll create basic pivot tables in R (summary tables), looking at it …

Posted on: September 17, 2017 Posted by: Guy Manova Comments: 0

Sums, means and other aggregates on Columns and Rows

How to quickly create a totals row (or column) for an R dataframe Follow the step by step tutorial to create a totals row for an R matrix or dataframe.   pre-session options rm(list = ls()) getwd() setwd(“C:/Users/your preferred path”) Let’s see various totals vectors to the Hitters and mtcars …

Posted on: September 16, 2017 Posted by: Guy Manova Comments: 0

Sumif,sumifs, countif, countifs etc in R

sumif in R (and sumifs, countifs etc.) follow this step by step to learn how to mimic some conditional summary excel functions such as sumif in R. you can copy paste code into Rstudio below, or just download the entire R file from github: Pre-session notes: As always, in order …