## How to quickly drop columns in R in data frame

Here are multiple ways how to drop one or multiple columns in the R data frame. You can use R base functionality or…

Journey in work with data

Here are multiple ways how to drop one or multiple columns in the R data frame. You can use R base functionality or…

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

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

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

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

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

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

If you are using R and getting dplyr error: `n()` must only be used inside dplyr verbs, then here is the most likely…

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…

Here is how to recode data in R in 3 different ways. Some may call it an efficient way how to replace existing…

Here is how to stop text overflow to the next Excel columns in 3 easy steps. The problem usually appears if you have…

Logarithmic transformation in R is one of the transformations that is typically used in time series forecasting. If your forecasting results have negative…

Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as…

Here is how to get necessary Salesforce data with R. Previously, there was a package RForcecom, but now you should use the salesforcer…

Here is a fun way to use Q&A functionality to build a data dictionary in Power BI. The first question might be –…

Here is how to connect to the Salesforce data with Power Query in Excel or Power BI. For the Salesforce CRM data exploration,…

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

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

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

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