Thomas Eapen · Selected presentation slides

Metaprogramming with R

I explored how R could automate processing while keeping calculations transparent to colleagues who use Excel.

Excel and R: Friends or Enemies? · A monthly data analytics meetup · 2020

4 selected slides · one-page overviewSelect a slide to enlarge itSlide order follows the original presentation
01

Keep Excel’s strengths

The presentation starts from Excel’s practical strengths: ease of use, spatial clarity and transparency for the people working with the data. Enlarge slide

Familiar tools offer ease of use, spatial clarity and transparency.

The presentation starts from Excel’s practical strengths: ease of use, spatial clarity and transparency for the people working with the data.

02

Automate with R

R is introduced for programmatic collection from sources such as Statistics Canada and OECD, automated calculations, and outputs including plots, dashboards, PDFs and Excel files. Enlarge slide

Retrieve data, perform calculations and generate different output formats.

R is introduced for programmatic collection from sources such as Statistics Canada and OECD, automated calculations, and outputs including plots, dashboards, PDFs and Excel files.

03

Give data a hierarchy

The data.tree package is presented as a way to build hierarchical structures from data frames, generate readable views, and query, filter or calculate across tree branches and nodes. Enlarge slide

Use data.tree to organise information and work with branches and nodes.

The data.tree package is presented as a way to build hierarchical structures from data frames, generate readable views, and query, filter or calculate across tree branches and nodes.

04

Keep formulas readable

The non-standard evaluation slide describes transparent, named formulas that work with tidy reshaping. A formula changed in a table can be reflected in calculations, reducing the black-box effect for non-R users. Enlarge slide

Named formulas help non-R users understand and adjust calculations.

The non-standard evaluation slide describes transparent, named formulas that work with tidy reshaping. A formula changed in a table can be reflected in calculations, reducing the black-box effect for non-R users.

Selected slide