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)
Hi David,
What other tutorials that are good for excel users to start learning R? I want to share them with my colleagues and teach them how to use R.
Thanks,
Benjamin
Posted by: Benjamin Chan | March 07, 2018 at 11:08
Great article! I love the emphasis on the use of Excel with R. I love R but Excel comes in very handy under time constrained projects. In some cases, Excel is quicker and more efficient to complete a job versus looking a way to complete via R.
Posted by: John W | March 13, 2018 at 05:43