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… Continue reading How to generate time intervals or date sequence in R

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 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… Continue reading How to run R scripts from the Windows command line (CMD)

Exit mobile version