Month: November 2019

How to combine numbers and find sums with R

In this post, I will explain the approach on how to combine numbers with R to find out which of them makes a certain sum. First of all, we will generate all possible number combinations from the vector or data frame column. That will give us multiple matrices. Then we will combine them in a… Continue reading How to combine numbers and find sums with R

How to add leading zeros in R, Power Query, DAX or Excel

Here are multiple examples of how to add leading zeros in different ways and places. In these examples, I will add them to number 123. As a result, I will get 5 digits (00123).

How to create BoxPlot in R and extract outliers

Outlier detection is a very broad topic, and boxplot is a part of that. Here is how to create a boxplot in R and extract outliers. There are few things to consider when creating a boxplot in R or anywhere else. Is boxplot showing all the necessary information? Sometimes it is important how many data… Continue reading How to create BoxPlot in R and extract outliers

How to restore closed unsaved script in RStudio

If you just recently closed the unsaved (untitled) source tab in RStudio, there is a good chance that you can get it back. Try to restore unsaved RStudio script in 3 different ways.

Run Windows command line scripts by condition

In the Windows command line, it is possible to build loops that periodically execute scripts. You can see how to do that in one of my previous posts. Let’s say you want to run R script from the Windows command line but with a condition or multiple conditions. For example, run R script from the… Continue reading Run Windows command line scripts by condition

How to combine Excel sheets with Power Query

Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI. With this approach, merging will continue even if new sheets with new tables will be created in the future.

Exit mobile version