Using R Markdown to create PDF files for sharing, you can chose several different options for printing tables of data: default, kable and tibble. If you are using HTML, you have another option called paged, which allows you to specify the number of rows and columns to display, and the viewer can page between pages …
First a little background – I’ve been working with R – the free open source statistical computing and graphics software for about a year, exploring various libraries and add-ons, trying to get a better understanding of it. This was spurred on by a couple of things. First, in SQL Server 2016, Microsoft incorporated R into …
As with many things I post here, this article was the result of a problem I encountered, and how to resolve or work around it. I have been working with Docker on Windows and was attempting to run a container provided by Microsoft that included SQL Server. The process is fairly easy, just pull the …
A new version of Mac OSX and a new version of Pentaho Data Integration (aka Kettle) but the same old problem getting Kettle to run. Apple tries to keep their operating system locked down and secure, so if you download applications from the Internet that aren’t from the Apple App Store, the files are quarantined. …
This is my second article on using Microsoft’s new Linux version of SQL Server with R. This time, I’ll cover how to use RODBC to gather data from SQL Server. As a bit of background, over the past few months, I have been working to learn R, a free software environment for statistical computing. Its been …
Over the past few months, I have been working to learn R, a free software environment for statistical computing. Its been gaining popularity over the past few years, and Microsoft just gave it a huge boost by integrating R into their Power BI visualization software and the Windows version of SQL Server 2016. Since a …