I had the great pleasure of speaking to the Department of Statistics and Actuarial Science at Simon Fraser University on last Friday to share my career advice with its students and professors. I emphasized the importance of learning skills in data manipulation during my presentation, and I want to supplement my presentation by posting some useful resources for this skill. If you are new to data manipulation, these are good guides for how to get started in R, SAS and Microsoft Excel.
For R, I recommend Winston Chang’s excellent web site, “Cookbook for R“. It has a specific section on manipulating data; this is a comprehensive list of the basic skills that every data analyst and statistician should learn.
For SAS, I recommend the UCLA statistical computing web page that is adapted from Oliver Schabenberger’s web site.
For Excel, I recommend Excel Easy, a web site that was started at the University of Amsterdam in 2010. It is a good resource for learning about Excel in general, and there is no background required. I specifically recommend the “Functions” and “Data Analysis” sections.
A blog called teachr has a good list of Top 10 skills in Excel to learn.
I like to document tips and tricks for R and SAS that I like to use often, especially if I struggled to find them on the Internet. I encourage you to check them out from time to time, especially in my “Data Analysis” category.
If you have any other favourite resources for learning data manipulation or data analysis, please share them in the comments!