## Day of the week number in R

There is R base function like weekdays that can return the name of the weekday. But what if you want to get the…

Journey in work with data

There is R base function like weekdays that can return the name of the weekday. But what if you want to get the…

1. Press Win + R keys to launch Run window and type “cmd”. 2. If you are Windows 10 user, then press Win…

R is great for data transformation, modeling, etc. automatization. In my case, I was collecting data and using library RDCOMClient to send summary…

This kind of problem when Excel crashes do not happen very often, but with no recovery options it can make you feel frustrated.…

Here is an example with getting LiveChat transcripts right into Microsoft Excel Power Query or Power BI. Chat conversations are not the most…

A few years ago I was participating in an Excel PivotTable contest, where the goal was to make the best PivotTable you can…

One thing I love about Microsft Power Query is the ability to make lists. It means that you can generate data without some…

Imagine – you copy beautiful chart as a picture from Excel to Outlook message and it becomes blurry. The same thing with PowerPoint…

Histograms are useful for data distribution visualization, and there are many possible ways how to make a histogram. Some may prefer Histogram option…

The first tip is a feature that is new to Windows 10. When you right-click on command prompt title bar and go to…

Well… not really. Just press Windows key and start typing. You can remove the search icon and gain some display space.

Here is how to apply the ifelse function across a range of multiple R data frame columns. Sometimes it is necessary to do…

The easiest way to do ISO week number and ISO year calculations in R is by using two simple functions from package lubridate.

Here is how to calculate variance across columns in the R data frame. The same technique can be useful in other situations. Like…

Here is how to generate a group index in R that restarts every time there change in variables.

You can calculate the moving average (also called a running or rolling average) in different ways by using R packages.

Here is how to use functions apply and match together in R and a result – return the name of the column that…

Do you want to edit R data frame like an Excel table? It is not possible the same way. But on the other…

R operator %in% is handy for work with vectors, but how to use it oppositely? Something like %notin% that will exclude anything that…

The easiest way to move the data frame column to a specific position in R is by using the function relocate from package…