Data Cornering

by Janis Sturis October 15, 2021 Comments0

R

How use dplyr distinct with exceptions, select unique rows in R

Here are several examples of how to use dplyr distinct to select only unique rows in the data frame. Examples starting with situations…

by Janis Sturis October 11, 2021 Comments0

Excel Power BI

Add custom button with a shortcut to Excel file in Power BI report

When the Power BI report is not enough, here is how to add an interactive button as a shortcut to the Excel file…

by Janis Sturis October 6, 2021 Comments0

R

How to bind R data frames vertically

Here is how to bind two or more R data frames vertically using different methods and dealing with possible errors. Binding R data…

by Janis Sturis September 21, 2021 Comments0

R

How to calculate weighted mean in R

Calculation of weighted mean in R is done easily by dedicated function or mathematically. Here are a couple of situations and solutions to…

by Janis Sturis September 21, 2021 Comments0

Excel

How to reset Excel chart plot area formatting

For me, the most annoying thing about Excel charts are is the inability to resize elements automatically. Usually, it happens after mild corrections…

by Janis Sturis September 9, 2021 Comments0

R

How to use password and token securely in R

Here is how to use password and token securely in R scripts using the keyring package and RStudio. This might be more helpful…

by Janis Sturis September 6, 2021 Comments0

DataViz Power BI

Power BI chart with the accented gap between two lines

Here is how to create a Power BI chart with an accented gap between two lines. With the help of fill color between…

by Janis Sturis September 6, 2021 Comments0

Excel Power BI

Color picker for Power BI or Excel

At this moment, there is no built-in color picker in Power BI or Excel, but here is how to use eyedropper PowerPoint. Eyedropper…

by Janis Sturis September 3, 2021 Comments0

CMD

Restart program with Windows command line

Here is an easy way to restart a program with the Windows command line by using the Windows command script. In this situation,…

by Janis Sturis August 30, 2021 Comments0

R

Detect combination of multiple strings in R

Here is how to detect multiple strings in R using base function grepl and alternatives, like str_detect from package stringr. There will be…