Sean Carney

Tag: R

  • Create Professional Reports in Excel using R and XLSX

    —

    by

    Sean Carney
    in

    While R is the real workhorse of data analysis and modeling, if you want to share the results of your work with other people your probably going to send it in a spreadsheet. Luckily the xlsx package for R makes it easy to export simple spreadsheets and also has advanced functionality to create workbooks with…

  • Scheduling R scripts to run automatically in Windows

    —

    by

    Sean Carney
    in

    A key component in data acquisition or reporting is the ability to trigger your script to run at a set time each day. Whether you are attempting to download the latest stock prices or update corporate earnings reports, once you’ve created the script to do the actual work, you need to find a way for…

  • Advanced email in R: embedding images and markdown

    —

    by

    Sean Carney
    in

    Previously we looked at how you can combine R and Markdown to create reports directly from your R scripts, and also how to send email from R using Microsoft Outlook. In this post, we’ll take these concepts a step further and look at how we can use R to embed images in email messages or…

  • Get started with RPA today using free tools

    —

    by

    Sean Carney
    in

    Robotic process automation (or RPA) is transforming the way many businesses handle their repetitious, labour intensive tasks such as reporting, making basic decisions, and providing services. Using software these tasks can be automated; reducing the time to complete tasks while also improving their accuracy and consistency. If you want to get started down the RPA…

  • Quickly create polished, professional reports with Markdown and R

    —

    by

    Sean Carney
    in

    One underappreciated feature in R is the ability to easily create beautiful reports using Markdown. Markdown files contain a combination of code and text, allowing you to write your analysis alongside your code and publish both the analysis document and code in a wide variety of formats with little effort.

  • Error catching, logging, and reporting in R with tryCatchLog

    —

    by

    Sean Carney
    in

    One of the biggest benefits from creating an automatic reporting framework is that you no longer need to directly supervise the creation and distribution of reports. However, when things go wrong it can be difficult to understand what went wrong and why. Luckily, R’s tryCatchLog package makes it easy to trap and log errors as…

  • Sending email from Outlook in R

    —

    by

    Sean Carney
    in

    When setting up automated reporting workflows, a key component is distributing the report to the various stakeholders so they can review it.  One useful technique is to send a “push notification” by email to alert everyone that a report or analysis task has just been completed.  Luckily, it isn’t hard to send out email from…