92 search results for "pivot table"

Interactive pivot tables with R

March 31, 2015
By
Interactive pivot tables with R

I love interactive pivot tables. That is the number one reason why I keep using spreadsheet software. The ability to look at data quickly in lots of different ways, without a single line of code helps me to get an understanding of the data really fast...

Read more »

Pivot Tables for R: Try sqldf

May 21, 2013
By

Pivot tables are a a growing staple for analysis in excel yet they remain limited to the functionality which Microsoft has chosen to include. Typical operations are the inclusion of filters, choice over rows, columns, and maths operations. In R … Continue reading →

Read more »

Pivot Tables and Medians in R

April 16, 2011
By

Pivot Tables are a useful way of aggregating data into the format that you’re after. In this example, I’m going to be using R to pivot some data and calculate medians for me. This is useful because Excel can calculate medians (the =MEDIAN(values)) function, but what it can’t do is calculate medians for Pivot Tables.

Read more »

Good riddance to Excel pivot tables

January 30, 2011
By
Good riddance to Excel pivot tables

Excel pivot tables have been how I have reorganized data...up until now. These are just a couple of examples why R is superior to Excel for reorganizing data:################ Good riddance to pivot tables ############library(reshape2)library(plyr)&nbsp...

Read more »

Pivot tables in R

January 9, 2010
By
Pivot tables in R

A common data-munging operation is to compute cross tabulations of measurements by categories. SQL Server and Excel have a nice feature called pivot tables for this purpose. Here we'll figure out how to do pivot operations in R.Let's imagine an experim...

Read more »

Deep Down Below – Using in-database analytics from within Tableau (with MADlib)

September 28, 2014
By
Deep Down Below – Using in-database analytics from within Tableau (with MADlib)

Introduction Using Tableau for visualizing all kinds of data is quite a joy, but it’s not that strong on build-in analytics or predictive features. Tableaus integration of R was a huge step in the right direction (and I love it very much - see here, here and here) but still has some limitations (e.g. no RAWSQL...

Read more »

How To: 20 Minute Guide to Get Started with PivotalR

July 1, 2014
By
How To: 20 Minute Guide to Get Started with PivotalR

In this article, Pivotal engineer and predictive analytics expert Hai Qian explains how someone new to R can get started performing statistical analysis on data stores in Greenplum Database, Pivotal HD and PostgreSQL in just 20 minutes using PivotalR. First, there is some background on R’s popularity, then the articles dives into important topics such as installation, data loading,...

Read more »

Automatically Exporting Multiple Cross Tables from Tableau Server into Excel

May 10, 2014
By
Automatically Exporting Multiple Cross Tables from Tableau Server into Excel

Introduction The following blog post is based on a classical reporting task most of the people working in BI got frequently: Besides all the nice dashboards you create in Tableau, from time to time people will approach you with a request for a “data extract” – reports that...

Read more »

Pivoting Data in R Excel-style

January 2, 2014
By
Pivoting Data in R Excel-style

(This article is referring to an initial proof-of-concept version of r-big-pivot) I have to admit that I very much enjoy pivoting through data using Excel. Its pivoting tool is great for getting a quick insight into a data set’s structure … Continue reading → The post Pivoting Data in R Excel-style appeared first on joy...

Read more »

Basic ideas on aggregate, plyr and crosstables!

October 17, 2012
By
Basic ideas on aggregate, plyr and crosstables!

A common task using R is the investigation of one particular dataset. Usually we have a mixture of numerical and categorial data and are interested in some statistics (e.g. means and so on). And there are a lot of threads, blogs etc around that. Sorry for adding another one, but so I remember myself. Let’s

Read more »

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)