Tag Archives: pivot tables

Using the reshape package in R for pivot-table-like functionality

A little more than a week ago, I wrote about creating pivot tables in Microsoft Excel and OpenOffice.org. I also mentioned that I would explain how to do similar calculations by using R. This post will explain how to achieve similar results in R by using the reshape package. I had initially started experimenting with [...]

Posted in (all categories), Geekiness, Useless Knowledge | Also tagged , , , , , , , , , , | 8 Comments

Pivot Tables in Excel and OpenOffice.org Calc

One of the features I find useful in Excel is the ability to create “pivot” tables. Essentially pivot tables let you summarize big tables of data in different ways, using different variables to “pivot” your data around (hence the name, I guess). Pivot tables are most easily understood through an example, so here’s one done [...]

Posted in (all categories), Geekiness, OpenOffice.org, Useless Knowledge | Also tagged , , , | Leave a comment