Function to check R package installation status

30. August 2016 how to, r 0
Function to check R package installation status
Today, I was updating a script that a coworker might use while I’m on vacation.  Knowing that she might not have some of the necessary packages installed on her machine, I wrote a function to check if the package was installed.  If the package is missing, the function will install it; if a package is already ...

Suppressing Duplicate Values in Microsoft Excel

22. July 2016 how to 0
Suppressing Duplicate Values in Microsoft Excel
  I needed to prepare an excel file with over 10,000 records for a user and wanted to suppress duplicate values in Excel to make it easier to evaluate the data.  Suppressing duplicates provides clarity to the data when many different values exist in a column.  I first ran across the ability to suppress duplicates in ...