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…
Latest Posts
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…
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…
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…
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…
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 and predictable groups, you…
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…
How to automatically upload files to SharePoint
Here is an example of how to automatically upload files to SharePoint Online by using PowerShell. By knowing how to run PowerShell script…
How to sync MS Teams files with local OneDrive folder
If you’re interested to use your MS Teams files like you usually would in File Explorer, then here is how to sync with…
Power Query error: We found extra characters at the end of JSON input
I was getting this error about extra characters at the end of JSON input while trying to connect to my JSON file in…
Reader PicksAll posts
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…
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…
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…
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…
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 and predictable groups, you…
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…
How to automatically upload files to SharePoint
Here is an example of how to automatically upload files to SharePoint Online by using PowerShell. By knowing how to run PowerShell script…
How to sync MS Teams files with local OneDrive folder
If you’re interested to use your MS Teams files like you usually would in File Explorer, then here is how to sync with…
Power Query error: We found extra characters at the end of JSON input
I was getting this error about extra characters at the end of JSON input while trying to connect to my JSON file in…
Power Query error: ResourceAccessForbiddenException
Here is one of the explanations if you have this Power Query error ResourceAccessForbiddenException while refreshing your data. If previously everything worked just…