Run batch file minimized
If you are running scheduled Windows batch files, then sometimes it could be more convenient to run batch file minimized.
in
How to preview part of PowerShell array
As I’m working in PowerShell ISE, I would like to take a quick look at my results in an array or hash table. Here is how to preview part of that.
Count unique values in column by using R
Here is the easy method of how to calculate the count of unique values in one or multiple columns by using R.
Remove duplicates and keep last in R
Here is how to remove duplicates but keep the last row in the R data frame.
in
Remove all objects except one or few in R
Sometimes you need an almost fresh start, and, in that case, here is how to remove all objects except one or few in R.
in
How to get top or bottom values by each group in R
It is easy to return top or bottom values by a group with functions slice_min and slice_max from dplyr in R. If you can’t find those functions, then you have to update dplyr.
Set Excel file read-only MS Teams, OneDrive, or SharePoint
Here is how to set Excel file read-only when using in MS Teams, OneDrive, or SharePoint. Those environments are different in the possibilities to change Excel file settings. Here is a quick walkthrough.
in
Remove scientific notation in R
Here is how to remove scientific notation in R. Sometimes, numbers as a result of calculation are not so small. It is hard to read them when they are in scientific formatting.
in
How to categorize numbers in R
Here is my approach on how to categorize numbers by user-defined groups with R. When you have a few predictable groups, you can use the ifelse function. But sometimes, there is a long list of numbers that are changing over time.
in
How to automatically download files from SharePoint
Here is an example of how to automatically download files from SharePoint Online by using PowerShell. By knowing how to run PowerShell script from the Windows command line (CMD) you can also build a workaround to download files during R or Python script execution.
in