Site icon R-bloggers

R data concepts, for Excel users

[This article was first published on Revolutions, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Excel users starting to use R likely have some established concepts about data: where it's stored, how functions apply to data, etc. In general, R does things differently to Excel (or any spreadsheet, in fact). In a useful guide, Steph de Silva from Rex Analytics explains the concepts of data management in R and how they differ from Excel, which provides a useful mental model for those making the transition or working in both. 


Click the image above for the complete guide, but in summary the differences are:

  • Excel stores data in the grid structure of the worksheet, whereas R stores data in individual objects, accessed and manipulated by the R language.
  • In Excel, code is formulas associated with cells of the worksheet. In R, code is functions provided by the R language or that you write yourself.
  • In Excel, you store the results of calculations in the worksheet, but in R results (like data) are stored in objects.

With these differences in mind, Excel users will have a much easier time adapting to R. Find the complete details at the link below.

Rex Analytics: Where do things live in R? R for Excel Users (via Mara Averick)

To leave a comment for the author, please follow the link and comment on their blog: Revolutions.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.