Publications by tomaztsql
Animated barplot and google map with R
It might happen that you will need a animated graph of any kind. For purposes of plotting demographic data and changes through the years, Google Maps and plotting maps, merging and converting jpg files into a animated gif, sure will give a nice visualization effect. Here is a sample of changes over the time period of three years on some dataset o...
1618 sym R (1354 sym/2 pcs) 14 img
RevoScaleR package for Microsoft R
RevoscaleR Package for R language is package for scalable, distributed and parallel computation, available along with Microsoft R Server (and in-Database R Services). It solves many of limitations that R language is facing when run from a client machine. RevoScaleR Package addresses several of these issues: memory based data access model -> da...
5804 sym R (1814 sym/13 pcs) 18 img
R and SQL Server articles
In past couple of months, I have prepared several articles on R and SQL Server that have been published on SQL Server Central. The idea was, to have couple of articles covering the introduction to R, to basics on R Server, to some practical cases on R with SQL Server. 1) Using Microsoft R in Enterprise Environments Article covers the concepts on ...
2946 sym 16 img
rxNeuralNet vs. xgBoost vs. H2O
Recently, I did a session at local user group in Ljubljana, Slovenija, where I introduced the new algorithms that are available with MicrosoftML package for Microsoft R Server 9.0.3. For dataset, I have used two from (still currently) running sessions from Kaggle. In the last part, I did image detection and prediction of MNIST dataset and compare...
1883 sym R (1696 sym/7 pcs) 10 img
RevoScaleR package dependencies with graph visualization
MRAN currently holds 7520 R Packages. We can see this with usage of following command (stipulating that you are using MRAN R version. ): library(tools) df_ap <- data.frame(available.packages()) head(df_ap) With importing package tools, we get many useful functions to find additional information on packages. Function package.dependencies() parses...
1352 sym R (698 sym/4 pcs) 8 img
Is it possible to use RevoScaleR package in Power BI?
I was invited to deliver a session for Belgium User Group on SQL Server and R integration. After the session – which we did online using web based Citrix – I got an interesting question: “Is it possible to use RevoScaleR performance computational functions within Power BI?“. My first answer was, a sceptical yes. But I said, that I hav...
5534 sym R (1124 sym/7 pcs) 18 img
Linear regression in “The Man who counted”
Recently, I got a book by Brasilian writer Júlio César de Mello e Souza (published under pen name Malba Tahan), titled The Man who counted. Book is a collection of mathematical stories very similar to Scheherazada’s 1001 Nights, where mathematical story-telling is the center of book. In story 5“In so many words”, Malba describes a simp...
2062 sym R (922 sym/7 pcs) 8 img
Saving input and output with sp_execute_external_script
Again I was at the point, where I needed to store and save to external file all the R code that was executed through sp_execute_external_script. Soon, you will find out several interesting things. To show the example, I will start with following example: USE [WideWorldImporters]; GO EXEC sys.sp_execute_external_script @language = N'R' ...
4129 sym R (2045 sym/6 pcs) 14 img
Saving input and output with sp_execute_external_script using temporal table and file table (part #2)
In my previous blog post, Saving input and output with sp_execute_external_script, I was exploring the possibilities how to capture the R code that external procedure sends it internally to the Launchpad.exe program. And a blog comment by reader Bob gave me additional push to write the second part to same topic. Thank you Bob for sharing this w...
4195 sym R (4020 sym/12 pcs) 12 img
Performance differences between RevoScaleR, ColumnStore Table and In-Memory OLTP Table
Running *.XDF files using RevoScaleR computational functions versus have dataset available in Columnstore table or in In-Memory OLTP table will be focus of comparison for this blog post. For this test, I will use the AirLines dataset, available here. Deliberately, I have picked a sample 200 MB (of 13GB dataset) in order to properly test the diffe...
3889 sym R (7243 sym/14 pcs) 10 img