Steven P. Sanderson II, MPH
LightNews LightNews
banner
spsanderson.com
Steven P. Sanderson II, MPH
@spsanderson.com
810 followers 330 following 1K posts
New Book: https://packt.link/oTyZJ
Site: https://www.spsanderson.com
Blog: https://www.spsanderson.com/steveondata
R - install.packages("healthyverse")
opinions are mine
Advisor to DoTadda
https://github.com/spsanderson
Posts Replies Media Videos
spsanderson.com
Iterating with #Google #AntiGravity #RAG #SQL #LLM
> how many readmits are there by payer group. Show the payer group and the readmit c ount. Make sure the readmit_flag = 1 Processing... 2025-11-26 17:11:10,926 - __main__ - INFO - Processing query: how many readmits are there by payer group. Show the payer group and the readmit count. Make sure the readmit_flag = 1 Batches: 100%|███████████████████████████████████████| 1/1 [00:00<00:00, 65.57it/s] 2025-11-26 17:11:10,947 - src.core.orchestrator - INFO - Generation attempt 1/3 2025-11-26 17:11:13,865 - src.core.orchestrator - INFO - Generated SQL: SELECT payer_grouping, COUNT(*) AS readmits FROM healthyR_data WHERE readmit_flag = 1 GROUP BY payer_grouping; --- Result --- Row Count: 12 Columns: ['payer_grouping', 'readmits'] Rows: {'payer_grouping': 'Blue Cross', 'readmits': 796} {'payer_grouping': 'Commercial', 'readmits': 241} {'payer_grouping': 'Compensation', 'readmits': 41} {'payer_grouping': 'Exchange Plans', 'readmits': 80} {'payer_grouping': 'HMO', 'readmits': 566} {'payer_grouping': 'Medicaid', 'readmits': 715} {'payer_grouping': 'Medicaid HMO', 'readmits': 1934} {'payer_grouping': 'Medicare A', 'readmits': 8007} {'payer_grouping': 'Medicare B', 'readmits': 29} {'payer_grouping': 'Medicare HMO', 'readmits': 1872} {'payer_grouping': 'No Fault', 'readmits': 61} {'payer_grouping': 'Self Pay', 'readmits': 91} Generated SQL: SELECT payer_grouping, COUNT(*) AS readmits FROM healthyR_data WHERE readmit_flag = 1 GROUP BY payer_grouping; Steps: - retrieval: 0.02s - generation_try_1: 2.92s - execution: 0.05s
November 26, 2025 at 10:13 PM
spsanderson.com
Working hard on building a system for work where people can ask natural language questions of our database using #Ollama and local #LLM so all calls stay local.

I used Reuven Cohen #SPARC framework to build a comprehensive build outline.

#Python #Ollama #LLM #SQL #Data
Working hard on building a system for work where people can ask natural language questions of our database using #Ollama and local #LLM so all calls stay local. I used Reuven Cohen #SPARC framework to build a comprehensive build outline. #Python #Ollama #LLM #SQL #Data
November 26, 2025 at 9:17 PM
spsanderson.com
Here I am using my #RandomWalker #RStats package to graph possible animal foraging paths. Many things can be done with some imagination :)

Reference Link: www.spsanderson.com/RandomWalker...
Here I am using my #RandomWalker #RStats package to graph possible animal foraging paths. Many things can be done with some imagination :) Reference Link: https://www.spsanderson.com/RandomWalker/articles/multi-dimensional-walks.html#use-cases Here I am using my #RandomWalker #RStats package to graph possible animal foraging paths. Many things can be done with some imagination :) Reference Link: https://www.spsanderson.com/RandomWalker/articles/multi-dimensional-walks.html#use-cases
November 21, 2025 at 1:12 PM
spsanderson.com
Just got this in the mail a dat or two ago, thanks Sam!
Patterns for building AI agents
November 21, 2025 at 12:33 PM
spsanderson.com
The Wages of Destruction by Adam Tooze. I have the print edition at home as well which i bought many years ago. Listening to it this time for a refresh as it seems to be an apropos time.
The Wages of Destruction by Adam Tooze. I have the print edition at home as well which i bought many years ago. Listening to it this time for a refresh as it seems to be an apropos time.
November 19, 2025 at 7:11 PM
spsanderson.com
#GitHub
#GitHub
November 18, 2025 at 1:08 PM
spsanderson.com
Construction moving along
November 8, 2025 at 3:40 PM
spsanderson.com
Home extension construction underway

#Construction
Foundation dig Foundation dig
November 7, 2025 at 7:03 PM
spsanderson.com
Some intelligence with image playground is pretty cool. I had to after 5.5 years get a new phone last night

#Apple #AppleIntelligence
November 7, 2025 at 6:54 PM
spsanderson.com
Doing some work on my #R package #RandomWalker and looks like we got a nice speedup coming for all of the generating functions. Over 2,000 replications saw a large speedup where the original function takes 2.8x as long as the new.

#RStats #RProgramming #Optimization
Doing some work on my #R package #RandomWalker and looks like we got a nice speedup coming for all of the generating functions. Over 2,000 replications saw a large speedup where the original function takes 2.8x as long as the new. #RStats #RProgramming #Optimization
November 2, 2025 at 12:38 AM
spsanderson.com
Working a script that will add run information after a stored procedure is executed. I want some basic information to run after each scheduled job to see a history, and to see if insert amounts look off if there is a late run or failure some place else.

#SQL #Technology
Working a script that will add run information after a stored procedure is executed. I want some basic information to run after each scheduled job to see a history, and to see if insert amounts look off if there is a late run or failure some place else. #SQL #Technology
October 30, 2025 at 12:56 PM
spsanderson.com
Summarizing health insurance payer policies in #R with #Ollama and #ragnar using qwen3
October 27, 2025 at 7:28 PM
spsanderson.com
Very beginning of learning #Ollama with #Python and #R
Very beginning of learning #Ollama with #Python and #R Very beginning of learning #Ollama with #Python and #R
October 20, 2025 at 4:15 PM
spsanderson.com
I wrote some code to use all of the available util_*_aic functions i have in my #TidyDensity #RStats package. It was a fun exercise. I was trying to see which distribution has the lowest #AIC

#R #Coding #Distribution #Statistics
I wrote some code to use all of the available util_*_aic functions i have in my #TidyDensity #RStats package. It was a fun exercise. I was trying to see which distribution has the lowest #AIC #R #Coding #Distribution #Statistics
October 17, 2025 at 4:12 PM
spsanderson.com
Decided to see what distribution my packages follow in terms of daily downloads and it looks like it's a Negative Binomial.

#R #RStats #Distributions #Download #CountData #GitHub

GitHub: github.com/spsanderson/...
Decided to see what distribution my packages follow in terms of daily downloads and it looks like it's a Negative Binomial. #R #RStats #Distributions #Download #CountData GitHub: https://github.com/spsanderson/random_r_projects/blob/main/density_estimation_for_healthyR_pkgs.r Decided to see what distribution my packages follow in terms of daily downloads and it looks like it's a Negative Binomial. #R #RStats #Distributions #Download #CountData GitHub: https://github.com/spsanderson/random_r_projects/blob/main/density_estimation_for_healthyR_pkgs.r
October 16, 2025 at 7:57 PM
spsanderson.com
Needed to combine .md files in sub-directories into a single one and place that file in the respective sub-dir, so I wrote this: github.com/spsanderson/...

#R #RStats #Script #Coding #Programming
https://github.com/spsanderson/random_r_projects/blob/main/combine_md_files.R
October 16, 2025 at 1:18 PM
spsanderson.com
I'm choice 2, using group_nest and map as it retains the original column types and there is no need to rename, although if I put some effort into it I'm sure I could remove the need to enframe and rename. I just don't feel like doing that this morning.

#tidyr #purrr #dplyr #imap #map #RandomWalker
I'm choice 2, using group_nest and map as it retains the original column types and there is no need to rename, although if I put some effort into it I'm sure I could remove the need to enframe and rename. I just don't feel like doing that this morning. #tidyr #tidyverse #purrr #dplyr #imap #map #RandomWalker
October 7, 2025 at 11:56 AM
spsanderson.com
Using the hai_data_trig() function from my package healthyR.ai

Reference: www.spsanderson.com/healthyR.ai/...

#R #RStats #datatransformation #DataScience #data #tidy #recipes #tidymodels
Using the hai_data_trig() function from my package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_trig.html #R #RStats #datatransformation #DataScience #data #tidy #recipes #tidymodels Using the hai_data_trig() function from my package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_trig.html #R #RStats #datatransformation #DataScience #data #tidy #recipes #tidymodels Using the hai_data_trig() function from my package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_trig.html #R #RStats #datatransformation #DataScience #data #tidy #recipes #tidymodels Using the hai_data_trig() function from my package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_trig.html #R #RStats #datatransformation #DataScience #data #tidy #recipes #tidymodels
October 3, 2025 at 2:38 PM
spsanderson.com
Doing data transformations with my healthyR.ai package.

#R #RStats #Programming #Data #Transformation

Reference: www.spsanderson.com/healthyR.ai/...
Doing data transformations with my healthyR.ai package. #R #RStats #Programming #Data #Transformation Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_transform.html Doing data transformations with my healthyR.ai package. #R #RStats #Programming #Data #Transformation Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_transform.html Doing data transformations with my healthyR.ai package. #R #RStats #Programming #Data #Transformation Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_transform.html
October 2, 2025 at 1:08 PM
spsanderson.com
did some work with my healthyR.ai #R #RStats #package with the hai_data_poly() function.

Take a look!

Reference: www.spsanderson.com/healthyR.ai/...
did some work with my healthyR.ai #R #RStats #package with the hai_data_poly() function. Take a look! Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_poly.html did some work with my healthyR.ai #R #RStats #package with the hai_data_poly() function. Take a look! Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_poly.html did some work with my healthyR.ai #R #RStats #package with the hai_data_poly() function. Take a look! Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_poly.html
October 1, 2025 at 6:23 PM
spsanderson.com
I see that the #CRAN downloads most likely maintained by @posit.co have not refreshed again, been a wicked few weeks meaning since the last outage.
I see that the #CRAN downloads most likely maintained by @posit.co have not refreshed again, been a wicked few weeks meaning since the last outage.
October 1, 2025 at 2:01 PM
spsanderson.com
Looks like the newest version of #RandomWalker and #TidyDensity are the best yet as seen in the 30 post release downloads. I don't get tidyverse downloads but I'm proud of these works.

#R #RStats
Looks like the newest version of #RandomWalker and #TidyDensity are the best yet as seen in the 30 post release downloads. I don't get tidyverse downloads but I'm proud of these works. #R #RStats Looks like the newest version of #RandomWalker and #TidyDensity are the best yet as seen in the 30 post release downloads. I don't get tidyverse downloads but I'm proud of these works. #R #RStats
September 30, 2025 at 2:38 PM
spsanderson.com
Now using the hai_data_scale() fns from healthyR.ai

Reference: www.spsanderson.com/healthyR.ai/...

#R #Rstats #tidydata #sttistics #data #normalization
Now using the hai_data_scale() fns from healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_scale.html #R #Rstats #tidydata #sttistics #data #normalization Now using the hai_data_scale() fns from healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_scale.html #R #Rstats #tidydata #sttistics #data #normalization Now using the hai_data_scale() fns from healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_scale.html #R #Rstats #tidydata #sttistics #data #normalization Now using the hai_data_scale() fns from healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_scale.html #R #Rstats #tidydata #sttistics #data #normalization
September 26, 2025 at 4:35 PM
spsanderson.com
Visualizing a few different imputation methods using the hai_data_impute() function from my #R package healthyR.ai

Reference: www.spsanderson.com/healthyR.ai/...
Visualizing a few different imputation methods using the hai_data_impute() function from my #R package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_impute.html Visualizing a few different imputation methods using the hai_data_impute() function from my #R package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_impute.html Visualizing a few different imputation methods using the hai_data_impute() function from my #R package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_impute.html Visualizing a few different imputation methods using the hai_data_impute() function from my #R package healthyR.ai Reference: https://www.spsanderson.com/healthyR.ai/reference/hai_data_impute.html
September 26, 2025 at 12:25 PM
spsanderson.com
I'm super proud of my wife who has passed her Library Media Specialist Certification exam!!!

#Library #LibraryMediaSpecialist #Media #Specialist #NYS
I'm super proud of my wife who has passed her Library Media Specialist Certification exam!!! #Library #LibraryMediaSpecialist #Media #Specialist #NYS
September 25, 2025 at 6:18 PM