Register with our Insider program to get a free companion PDF to help you better follow the tips and code in our story, "Data manipulation tricks: Even better in R."
In the PDF, we tell you how to extract month, day and year from each date in a column, calculate ages, search and replace text, use a wildcard search, deal with IF statements and reshape data, among other things.
[ Andrew C. Oliver answers the question on everyone's mind: Which freaking database should I use? | Keep up with the latest approaches to managing information overload and compliance in InfoWorld's Enterprise Data Explosion Digital Spotlight. ]
(The original Excel tips, upon which this is based, come from MaryJo Webster, senior data reporter with Digital First Media.)