Just an FYI – this site is now running with the HTTPS protocol rather than HTTP. If you have links to the old address, please update them. Thanks! Why some of you may ask? There are a variety of reasons, but they all revolve around security. If you use Chrome and visit an HTTP site, …
It’s been awhile since I’ve posted a photo (or anything else – work and personal life extremely busy as of late) so here is an image from Denver last week. It was a short three day trip, but got to a lot of different areas. A beautiful part of the United States to visit and …
I’m back, after my day job related hiatus! This time I’m looking at installing RStudio’s open source version of Shiny Server on Linux Mint. If you aren’t familiar with Shiny, its a product from the RStudio team that provides a web framework to host interactive data analysis apps using a variety of different technologies including …
Here we are at the last part for this series. To recap, in the first 2.5 parts of this series (part 1, part 2, part 2.5) I focused on setting up a graph database in SQL Server, and querying the metadata to discover the nodes and edges that define the structure of the graph. In the …
The first 2.5 parts of this series (part 1, part 2, part 2.5) focused on setting up a graph database in SQL Server, and querying the metadata to discover the nodes and edges that define the structure of the graph. In this part, we shift over to R and imbed the SQL Server cursor script …
Quick post tonight. While working on some examples to test out the cursor I posted in Part 2, I realized that I had only coded the cursor to retrieve information for the dbo schema. So here I present the revised cursor which pulls from any schema. If a table is part of the dbo schema …
If you’ve been using R for even a short time, you more than likely have heard of the Tidyverse from RStudio and originally developed by Hadley Wickham. As explained on the tidyverse website this set of packages works together with a common data representation methodology and API design. They provide a host of functionality to clean …
In R Markdown include footnotes in documents to provide a reference or comment that may provide additional context or an aside to the topic. Traditionally, these numbered notes are placed at the bottom of the page and a corresponding superscript number is added to the text body at the relevant text. R Markdown supports footnotes …
Wrapping up the year with a few simple tips for R Markdown that work with PDF, Word or HTML output. \VSPACE When you insert a series of blank lines in an R Markdown document and knit the document, the parsing of your document strips out those blank lines. As an example I entered in my …
R Studio is a popular IDE to use with R and runs on Windows (7/8/10), Mac OS X (10.6+) and the most widely used Linux distributions: Debian/Ubuntu and Fedora/Red Hat/OpenSuSE. For Linux, that generally means installation on any other distributions that are derivatives of these should also work with with minimal effort. For my personal …