Category: R
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 of the previous post I was modifying my Rprofile.site file and there is definitely a connection with this error.
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 example, you have to make summary statistics for 15 minute time intervals in R. There might be situations wherein a 15 minute interval is no data. It is necessary to, first of…
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 environments.
How to switch from Excel to R
As an Excel user for many years, I’m periodically trying new things to work with data and one of them was R. If you are interested in R, then here are a few tips and inspirational words that worked for me and may work for you.
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 spreadsheet, and, depending on the amount of data that I want to copy, there are different solutions to that process.
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 + X to open Quick Link menu and press C. 3. If you are the RStudio user, then switch to Terminal in your Console pane.
How to run R scripts from the Windows command line (CMD)
R is excellent for data transformation, modeling, etc. automatization. It is possible to run R scripts from the command line. In my case, I was collecting data and using library RDCOMClient to send summary information to colleges with Microsoft Outlook, but I needed it to do that automatically. It is possible to run R scripts…