Have you ever been a part of a Facebook group where members post “f” or “.” on a post and wonder why they do this? Have you also noticed that some admins and group members get really irritated by this?…
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…
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…
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…
Objective I needed to learn how to use the Nmap and Zenmap tools for devices connected to my network. The first video below is by far the one I would consider to be the most valuable. The others had good…
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…
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…
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…
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…