How to quickly build R data frame from scratch with Excel
If you know some of the Excel text functions, you can quickly build R data frame from scratch. Also, you should understand how…
Latest Posts
How to quickly build R data frame from scratch with Excel
If you know some of the Excel text functions, you can quickly build R data frame from scratch. Also, you should understand how…
Run Windows command line scripts by condition
In the Windows command line, it is possible to build loops that periodically execute scripts. You can see how to do that in…
How to combine Excel sheets with Power Query
Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI.…
How to unlist a nested list in R
Here is a simple tutorial on how to unlist a nested list with the help of R. Problems may appear when nested lists…
How to combine files with R and add filename column
Here is a simple way how to combine CSV or text files with R and, at the same time, add a column with…
How to clear RStudio panes with code
Here is how to clear RStudio console, environment and plot windows (panes) individually or at the same time by using code (a combination…
dplyr error in select: unused argument
Unused argument error might appear with any function (for example, dplyr), and the primal cause is a misunderstanding. If function appears in multiple…
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 run Excel file from Windows 10 Task Scheduler
Sometimes, when Excel file contains macros that can run automatically when the file opens, there is a need to do that periodically and…
Reader PicksAll posts
How to quickly build R data frame from scratch with Excel
If you know some of the Excel text functions, you can quickly build R data frame from scratch. Also, you should understand how…
Run Windows command line scripts by condition
In the Windows command line, it is possible to build loops that periodically execute scripts. You can see how to do that in…
How to combine Excel sheets with Power Query
Here is a simple and easy way how to combine tables from multiple Excel sheets with Power Query in Excel or Power BI.…
How to unlist a nested list in R
Here is a simple tutorial on how to unlist a nested list with the help of R. Problems may appear when nested lists…
How to combine files with R and add filename column
Here is a simple way how to combine CSV or text files with R and, at the same time, add a column with…
How to clear RStudio panes with code
Here is how to clear RStudio console, environment and plot windows (panes) individually or at the same time by using code (a combination…
dplyr error in select: unused argument
Unused argument error might appear with any function (for example, dplyr), and the primal cause is a misunderstanding. If function appears in multiple…
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 run Excel file from Windows 10 Task Scheduler
Sometimes, when Excel file contains macros that can run automatically when the file opens, there is a need to do that periodically and…
How to run Excel macro on file opening
Here is how to run Excel macro automatically every time you open the file in a few easy steps.