Why is Rounding so Difficult?
I was today years old when I learned that the way I learned to round in school was not how everyone rounded. I was taught that the value 1.65, when rounded to one decimal point, would result in 1.7. Today…
Category Programming
Calculating Time Difference in R
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…
Two Ways to Benchmark Your R Scripts
Sometimes you need to know how long your scripts take to process in order to make improvements or to get an idea of how long it will take to process in the future. Most times, I could care less about…
Counting the Number of Weekdays from a Date Range in R
Recently, I needed to be able to extract the number of weekdays from a date range and calculate a percentage so that accruals could be mapped to the appropriate month. I wasn’t able to find exactly what I needed to…
Writing Array Elements to CSV in Ruby
There is nothing more frustrating than realizing that a ruby script failed when processing, and you do not know where it failed and where to pick up the processing. Having the ability to write results or values out to a…
Visual Studio Code Is Not Recognizing Emmet Abbreviations in ERB Files
Emmet is a standard feature that is built into Visual Studio Code (Code) and generally recognizes all file types. However, after installing Code, Emmet does not auto-expand abbreviations when working in ERB files. Fortunately, it’s a simple and very fast…
3 Reasons to stop working in Excel and start using RStudio
Excel is a fantastic tool and a workhorse of an application. Anywhere you work, it’s there! However, when you really try to get some serious analysis done, you will find that you quickly run into walls with limits on what…
Subsetting and Filtering a Data Frame in R (base R)
When I was first learning R in a Coursera course from Johns Hopkins University, subsetting and filtering was one of the first things I learned how to do in R. Subsetting is essentially scaling down your data frame so that…
What is a Data Frame in R?
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…
How to add a new column to a data frame in R
One of the first things I struggled with when learning to write R code, was how to add a new column to a data frame in R. For example, we have a data frame, userdata, with the following three columns…