Extracting Data with an API and RStudio

30. July 2016 data, r 0
Extracting Data with an API and RStudio
Recently, I needed to be able to extract analytics data from our provider before the last day of our contract.  We were moving to a much more robust system, and they were being less than helpful and very unresponsive.  That was when I remembered that they have an API available for extracting data.  The API allows ...

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 ...

There has to be a better way

14. July 2016 data, programming, r 1
There has to be a better way
On my journey to becoming an R data ninja, I’ve learned a lot and have come a long way.  However, today, I found myself writing a ginormous nested ifelse statement in R.  I needed to code the quarter (Q1, Q2, Q3, and Q4) for over 6,000 rows and standard packages weren’t cutting it.  The Lubridate ...