Mac keyboard on laptop

Tag data

Calculating Time Difference in R

Photo of old-school clocks with different times on the face.

Recently, I needed to calculate the time difference between two times that were exported from a system. The times in the report were formatted like “07:30:00 AM” or “04:00:00 PM”. This data in this particular data set does do not…

What is a Data Frame in R?

RStudio IDE showing code to create a data frame.

I use data frames nearly every time I write a script in R. I’m usually reading and storing the contents of several CSV files to process its contents. The more you work in R, the more you are likely to…

What is a Data Warehouse?

Aerial shot of trains in a line

A data warehouse, distilled to its simplest form, is a database that contains different tables of data that do not change over time. Query and dashboarding tools can be placed on top of the data warehouse to help the business…