This post follows a previous tutorial on pivoting on text in Excel. In this post I will reproduce the exercise in R. This way you begin to see the similarities and differences of the program and begin …
Pivoting on Text in Excel: Awards by Player PivotTable
This post is inspired by a Mr. Excel tutorial on using "text instead of numbers in a Pivot Table." Our goal is to create a Pivot-Table like report that creates a comma-separated list …
Continue Reading about Pivoting on Text in Excel: Awards by Player PivotTable →
Why Your Next Worker Should Be a Blogger
A major theme of this blog has been getting "Hired with Excel." This was motivated by my own experience as a liberal arts grad, seeing the importance of Excel for my employment prospects. Knowing one …
Continue Reading about Why Your Next Worker Should Be a Blogger →
How Fiction Makes Me a Better Analyst
It is my hope that this blog goes beyond simple tips and tricks into helping people become more fluent in data and, by consequence, innovation. One of my first and still favorite blog posts was on …
Continue Reading about How Fiction Makes Me a Better Analyst →
Creating the Future with the Liberal Arts
Recent college graduates are in the envious position of entering the best labor market in decades. But, in the spirit of Mark Twain, I encourage new workers not to let their job get in the way of …
Continue Reading about Creating the Future with the Liberal Arts →
R Functions for Reproducible Data Frames
While there are many great resources to get help in R, sometimes you just need a second opinion. Here is where the many Internet help boards come in handy, most notably Stack Overflow. …
Continue Reading about R Functions for Reproducible Data Frames →