Category: Pivot Tables

Posted on: December 18, 2017 Posted by: Guy Manova Comments: 0

show values as difference from previous in R

Excel show values as difference from previous in R In this short tutorial learn how to emulate Excel show value as difference from previous in R. In Excel In R # pre-session options rm(list = ls()) # getwd() # setwd(“your preferred file folder”) df <- read.csv(“https://www.dropbox.com/s/uhp0ne0rdxk9k7r/stocks.csv?dl=1”) write.csv(df, “stocks.csv”) library(dplyr) library(tidyr) …

Posted on: December 5, 2017 Posted by: Guy Manova Comments: 0

Running totals (cumulative sums) in R

Running totals (cumulative sums) in R in this short tutorial, learn how to create Running totals (cumulative sums) in R using cumsum() in different scenerios including pivot table, just like you would use Excel’s pivot table “show values as” and selecting “running total” or “% running total” In Excel   …

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

Percent of total, pivot table “show values as” in R

mimicking “show value as” in R, as well as generally doing percent of total in R This is a short tutorial on how you can mimic Excel’s pivot table “show value as” functionality, as well as generally showing how to create a proportion table (prop table) to compute percent of …

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 …