Python Pandas multiIndex is a hierarchical indexing over multiple tuples or arrays of data, enabling advanced dataframe wrangling and analysis on higher data dimensionality. Everyone have had come across multiIndex...continue reading.
Structure() function is a simple, yet powerful function that describes a given object with given attributes. It is part of base R language library, so there is no need to...continue reading.
So this came as a surprise, when working on calculating simple statistics on my dataset, in particular min, max and median. First two are trivial. The last one was the...continue reading.
Using Python with SQL Server 2017 SSRS should not be an obstacle, since the framework and the technology is the same as with R language. With SQL Server 2017, Python...continue reading.
Having all the R functions, all libraries and any kind of definitions (URL, links, working directories, environments, memory, etc) in one file is nothing new, but sometimes a lifesaver. Using...continue reading.
R has been around long time and the packages have evolved through the years as well. From the initial releases, updates, to new packages. Like many open-source and community driven...continue reading.
Yes, I am finally blogging this. 🙂 This blog post is slighty different, since it brings you the tittle of the book, that my dear friend Julie Koesmarno (blog |...continue reading.
In the previous post, I have showed how to visualize near real-time data using Python and Dash module. And it is time to see one of the many ways, how...continue reading.
In the SQL Server Management Studio (SSMS), the ease of using external procedure sp_execute_external_script has been (and still will be) discussed many times. But the reason for this short blog...continue reading.
Azure Machine Learning Studio has been around for the past 3 years and a lot of new features have been added. I am positive, many more will follow. One of...continue reading.
The need for visualizing the real-time data (or near-real time) has been and still is a very important daily driver for many businesses. Microsoft SQL Server has many capabilities to...continue reading.