How to run R script from another R script and use as a source
Here is a solution with running R script from another R script and using as a source. It comes handy when R script…
How to create group index with Power Query or R
It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when…
Incomplete final line found on Rprofile.site when installing from GitHub
I was stumbling on this “incomplete final line found on Rprofile” error while installing d3rain package with the following code remotes::install_github(“daranzolin/d3rain”). In one…
How to generate time intervals or date sequence in R
In this post, you will get summary and code examples for creating time intervals, date or date-time sequence different ways in R. For…
How to calculate today’s date in Excel, VBA code in Excel, DAX, Power Query, R, PowerShell, CMD and SQL
No matter what kind of tool you use need to get today’s date remains. Here is how to do that in eight different…
How to switch from Excel to R
As an Excel user for many years, I’m periodically trying new things in work with data and one of them was R. If…
How to copy the R data frame to Excel and customize your startup
Very often I use RStudio and Excel all together. In that situation, sometimes I want to copy some R results in the Excel…
How to quickly open Windows command prompt
1. Press Win + R keys to launch Run window and type “cmd”. 2. If you are Windows 10 user, then press Win…
