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…
Latest Posts
Stop text overflow into next Excel columns
Here is how to stop text overflow to the next Excel columns in 3 easy steps. The problem usually appears if you have…
My top 10 favorite dplyr tips and tricks
Here is a compilation of my favorite dplyr tips and tricks that are very useful and easy to learn. When I started to…
Round, roundup, rounddown, trunc in R
Here is how to round or truncate numbers, dates, and times in R in different ways. Depending on your goals and situation, there…
5 ways how to format output in R console
Here is how to format output in the R console in 5 different ways to make your dataset look better if that’s necessary.…
Get the first and last row of the data group in R
If your data frame content is categorized and you are interested to extract the first and the last row of each group in…
Power BI line chart that conditionally changes formatting
Here is how to create a Power BI line chart that at some point continues in a different design, formatting. For example, it…
Last available column value in Power BI
Here is how to detect the last available column value in Power BI in almost any situation. The main problem is columns with…
Add index column in Power Query
Here is how to add an index column in Power Query in 2 easy steps. Index column in Power Query might be useful…
Calculate the percentage by a group in R, dplyr
Here is how to calculate the percentage by group or subgroup in R. If you like, you can add percentage formatting, then there…
Percentage format in R
Here is how to apply percentage format to decimal numbers in R and treat them as numeric. That is important if you would…
Reader PicksAll posts
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…
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…
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…
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…
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…
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,…
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…
dplyr error: `n()` must only be used inside dplyr verbs
If you are using R and getting dplyr error: `n()` must only be used inside dplyr verbs, then here is the most likely…
Pac-Man (two slice pie) chart in Excel, rotate Excel pie chart slice
If your data contains two categories, don’t miss a chance to create a Pac-Man chart in Excel. It might not work all the…
Recode data in R, replace values
Here is how to recode data in R in 3 different ways. Some may call it an efficient way how to replace existing…