iiinova — where your digital self keeps evolving

Russell Shean @rshean.bsky.social · 31/12/2025

I'm working on a #python package to create #PowerBI dashboards. As a demonstration of the package, I used the package to finish the Week 13 #WOW2025 challenge by @sqlgene.com. Here's a link: www.russellshean.com/powerbpy/exa... @mmarie.bsky.social @shan-gsd.bsky.social @merrykerry.bsky.social

This is a screenshot of the original dashboard. The dashboard can be viewed here: https://workout-wednesday.com/pbi-2025-w13/

This is a screenshot of the dashboard I recreated using only python. I didn't open Power BI desktop until the end just to view the file.

Here's a screenshot of the code I used to create the dashboard. The full code and the data processing scripts I also used are available here: https://www.russellshean.com/powerbpy/example_dashboards/Sanky%20Chart%20and%20Table/chart_and_table.html

1121 12

Russell Shean @rshean.bsky.social · 18/12/2025

Hi #rstats, any best practices for which environment files should be ignored for R projects? I noticed that the GitHub standard .gitignore template has .Renviron, but I want to make a pull request to add .env too. Is there a reason not to? Should I add anything else? github.com/github/gitig...

github.com

gitignore/R.gitignore at main · github/gitignore

A collection of useful .gitignore templates. Contribute to github/gitignore development by creating an account on GitHub.

141 4

Russell Shean @rshean.bsky.social · 30/01/2025

For Windows This assumes no admin rights, if you have admin rights there are more options: superuser.com/a/1026940 1. Find your #Rstats executable 2. Create a new folder 3. Inside folder add a batch script to launch R with --no-save arg 4. Add folder to path gist: gist.github.com/Russell-Shea...

FIRST HALF

Here are some commands you can run in command prompt to

1. create a new folder called "my_custom_bin"
2. create a batch script inside "my_custom_bin" with the following:

@echo off
"C:/Program Files/R/R-4.4.2/bin/r.exe" --no-save

These commands could be run individually in a command prompt window or as a batch script. These steps could also be done manually. Code is available as gist in link above.

SECOND HALF

Here are some commands you can run in command prompt to

1. create a new powershell script
2. execute the powershell script to add "my_custom_bin" to the path

These commands should be run after the commands in the first screenshot. They could be run individually in a command prompt window or combined with the first screenshot as a batch script. The powershell script could also be run directly in powershell.....
You can add to the path manually by going to "edit environmental variables for your account" in control panel, then edit "Path" under user variables and then add the full path to "my_custom_bin"

After you're finished setting all this up, any time you type "R" in a terminal, windows will search the path, find the R.bat file in "my_custom_bin" and execute the batch script. The batch script will launch R with the --no-save option enabled.

This may not work if R is already on your path?

020 2

Russell Shean @rshean.bsky.social · 29/01/2025

Ha! I figured out how to disable the "save workspace image ?" prompt when exiting #Rstats from a terminal Here's how I did it (in Ubuntu; I'm going to solve windows cmd tomorrow at work) Details in alt text! credit to this blog that I shamelessly copied from: www.r-bloggers.com/2009/03/r-ti...

050 5

Russell Shean @rshean.bsky.social · 06/01/2025

Thanks @edenian-prince.bsky.social for inviting to help make this closeread...and for doing most of the work 😅 It's really cool how leaflet maps can be embedded directly into the html. Next time I want to try shinylive or something to embed a shiny instead of just using an iframe like we did here.

020 2