John MacKintosh
@johnmackintosh.bsky.social
data specialist in the NHS, Scotland.
Experience with clinical audit, quality improvement, BI and public health.
Likes #RStats and #dataviz
Formerly HighlandR , still at
https://johnmackintosh.com
Experience with clinical audit, quality improvement, BI and public health.
Likes #RStats and #dataviz
Formerly HighlandR , still at
https://johnmackintosh.com
My wife was talking to me about something boring, and I laughed out loud at "yeet", so , yeah, got busted for my inattention, no cap
November 7, 2025 at 3:47 PM
My wife was talking to me about something boring, and I laughed out loud at "yeet", so , yeah, got busted for my inattention, no cap
September 30, 2025 at 5:04 PM
There used to a page somewhere on the rstudio site about resetting a hidden state folder (which meant renaming it, and then RStudio would create a new version on the next open)
This helped me a couple of times, and also another colleague who was seeing some weird behaviour
Will try and find link
This helped me a couple of times, and also another colleague who was seeing some weird behaviour
Will try and find link
September 30, 2025 at 5:01 PM
There used to a page somewhere on the rstudio site about resetting a hidden state folder (which meant renaming it, and then RStudio would create a new version on the next open)
This helped me a couple of times, and also another colleague who was seeing some weird behaviour
Will try and find link
This helped me a couple of times, and also another colleague who was seeing some weird behaviour
Will try and find link
I always understood it as not being safe in a script you might share with others, as running that code may remove objects that they require for their analysis.
If you don't share code, then do what you want, and enjoy shouting at yourself if things go wrong 😁
If you don't share code, then do what you want, and enjoy shouting at yourself if things go wrong 😁
September 26, 2025 at 7:17 AM
I always understood it as not being safe in a script you might share with others, as running that code may remove objects that they require for their analysis.
If you don't share code, then do what you want, and enjoy shouting at yourself if things go wrong 😁
If you don't share code, then do what you want, and enjoy shouting at yourself if things go wrong 😁
Used it for the first time a few weeks ago.
The only time I ever use tibble specifically is for the rare occasions I need these inline tribbles, which I would then convert to DT.
Now I can cut that step out
The only time I ever use tibble specifically is for the rare occasions I need these inline tribbles, which I would then convert to DT.
Now I can cut that step out
September 2, 2025 at 7:21 AM
Used it for the first time a few weeks ago.
The only time I ever use tibble specifically is for the rare occasions I need these inline tribbles, which I would then convert to DT.
Now I can cut that step out
The only time I ever use tibble specifically is for the rare occasions I need these inline tribbles, which I would then convert to DT.
Now I can cut that step out
Clubcard FTW
a man in a purple suit is laughing with the words points baby
ALT: a man in a purple suit is laughing with the words points baby
media.tenor.com
August 4, 2025 at 7:47 PM
Clubcard FTW
I've just accidentally scanned this in Tesco. Cost me £2.99
August 4, 2025 at 6:09 PM
I've just accidentally scanned this in Tesco. Cost me £2.99
I've left this unchecked, but have found the keystrokes to obtain the native pipe have quickly become second nature.
So much so, that if I do check this box, hitting ctrl-shft-m is going to feel weird.
While I still don't love the placeholder shenanigans, I am native piping >70% of the time now
So much so, that if I do check this box, hitting ctrl-shft-m is going to feel weird.
While I still don't love the placeholder shenanigans, I am native piping >70% of the time now
July 10, 2025 at 8:09 PM
I've left this unchecked, but have found the keystrokes to obtain the native pipe have quickly become second nature.
So much so, that if I do check this box, hitting ctrl-shft-m is going to feel weird.
While I still don't love the placeholder shenanigans, I am native piping >70% of the time now
So much so, that if I do check this box, hitting ctrl-shft-m is going to feel weird.
While I still don't love the placeholder shenanigans, I am native piping >70% of the time now
Don't have a solution, but just want to show some solidarity - this absolutely does my head in.
June 13, 2025 at 8:41 PM
Don't have a solution, but just want to show some solidarity - this absolutely does my head in.
Wait - are these not there for you?
May 29, 2025 at 10:48 AM
Wait - are these not there for you?
Really nice
I've been working with population pyramids too. Waiting for some updated projections. The shape of the pyramids is wildly different.
I've used a similar approach in the past - looping to create separate images then stitched together to make a gif. I used {gifski} which was pretty fast.
I've been working with population pyramids too. Waiting for some updated projections. The shape of the pyramids is wildly different.
I've used a similar approach in the past - looping to create separate images then stitched together to make a gif. I used {gifski} which was pretty fast.
May 17, 2025 at 9:02 AM
Really nice
I've been working with population pyramids too. Waiting for some updated projections. The shape of the pyramids is wildly different.
I've used a similar approach in the past - looping to create separate images then stitched together to make a gif. I used {gifski} which was pretty fast.
I've been working with population pyramids too. Waiting for some updated projections. The shape of the pyramids is wildly different.
I've used a similar approach in the past - looping to create separate images then stitched together to make a gif. I used {gifski} which was pretty fast.
You may be interested in seq.Date() too..it should be more reliable than seq for handling dates
May 16, 2025 at 9:55 PM
You may be interested in seq.Date() too..it should be more reliable than seq for handling dates
Loading the entire tidyverse to write 4 lines of dplyr:
a man in a colorful jacket and tie is standing in front of a green door .
Alt: Joey off of Friends wearing a colorful jacket and tie and many other items of clothing standing in front of a green door .
Increasingly, I find myself wanting to write as little code as possible.. That doesn't necessarily mean base R, and it doesn't mean I avoid tidyverse, it means I use what I feel is necessary to get the job done
media.tenor.com
May 1, 2025 at 7:03 AM
Loading the entire tidyverse to write 4 lines of dplyr:
I created a 24/7 heatmap years ago for this very purpose.
You'll find it somewhere on my blog, or in the R graph gallery
You'll find it somewhere on my blog, or in the R graph gallery
April 29, 2025 at 9:33 AM
I created a 24/7 heatmap years ago for this very purpose.
You'll find it somewhere on my blog, or in the R graph gallery
You'll find it somewhere on my blog, or in the R graph gallery
I think you simply have to say "this can't be done"
Then wait for someone to prove it can
Then wait for someone to prove it can
April 27, 2025 at 8:10 AM
I think you simply have to say "this can't be done"
Then wait for someone to prove it can
Then wait for someone to prove it can
music.youtube.com/watch?v=7idy...
One of the best live rock bands right now, this will have you tapping your foot and singing along (badly, in my case)
One of the best live rock bands right now, this will have you tapping your foot and singing along (badly, in my case)
Consume
YouTube video by The Warning - Topic
music.youtube.com
April 26, 2025 at 11:21 AM
music.youtube.com/watch?v=7idy...
One of the best live rock bands right now, this will have you tapping your foot and singing along (badly, in my case)
One of the best live rock bands right now, this will have you tapping your foot and singing along (badly, in my case)
It seems that it's very difficult to write about tidy evaluation without a bunch of extra, increasingly confusing theory, and has been the case since it was introduced.
"Oh you're drowning in the meta programming waters..would you like some MORE SEA?"
No, get me to land, with a towel and dry socks
"Oh you're drowning in the meta programming waters..would you like some MORE SEA?"
No, get me to land, with a towel and dry socks
April 25, 2025 at 7:31 AM
It seems that it's very difficult to write about tidy evaluation without a bunch of extra, increasingly confusing theory, and has been the case since it was introduced.
"Oh you're drowning in the meta programming waters..would you like some MORE SEA?"
No, get me to land, with a towel and dry socks
"Oh you're drowning in the meta programming waters..would you like some MORE SEA?"
No, get me to land, with a towel and dry socks
Would you consider adding these 2 tweets or a summary of them to your blog post as a TL/DR?
Would be immensely helpful for future reference
Would be immensely helpful for future reference
April 25, 2025 at 7:19 AM
Would you consider adding these 2 tweets or a summary of them to your blog post as a TL/DR?
Would be immensely helpful for future reference
Would be immensely helpful for future reference
To be fair, I didn't know you could lick a badger _once_, let alone twice.
April 23, 2025 at 1:58 PM
To be fair, I didn't know you could lick a badger _once_, let alone twice.
The other thing is the order of operations.
How much filtering can you do up front, prior to merging / pivoting.
Arrow seems like a good suggestion - you can always read those files into a in-memory duckdb
I'm pretty much converted to data.table for general wrangling, especially pivot/unpivot
How much filtering can you do up front, prior to merging / pivoting.
Arrow seems like a good suggestion - you can always read those files into a in-memory duckdb
I'm pretty much converted to data.table for general wrangling, especially pivot/unpivot
April 22, 2025 at 10:37 PM
The other thing is the order of operations.
How much filtering can you do up front, prior to merging / pivoting.
Arrow seems like a good suggestion - you can always read those files into a in-memory duckdb
I'm pretty much converted to data.table for general wrangling, especially pivot/unpivot
How much filtering can you do up front, prior to merging / pivoting.
Arrow seems like a good suggestion - you can always read those files into a in-memory duckdb
I'm pretty much converted to data.table for general wrangling, especially pivot/unpivot
Haven't seen {reactablefmtr} mentioned, but you can create some beautiful reactive tables with it.
Other than that, flextable is my day to day choice (due partly to its excellent MS Word support)
Other than that, flextable is my day to day choice (due partly to its excellent MS Word support)
April 12, 2025 at 12:41 AM
Haven't seen {reactablefmtr} mentioned, but you can create some beautiful reactive tables with it.
Other than that, flextable is my day to day choice (due partly to its excellent MS Word support)
Other than that, flextable is my day to day choice (due partly to its excellent MS Word support)
I'll do anything for R.
But I won't do _that_
But I won't do _that_
April 11, 2025 at 7:21 AM
I'll do anything for R.
But I won't do _that_
But I won't do _that_
depends on the project.
For a simple one, might just end up in /outputs, for a more complex project,. probably /outputs/img
For a simple one, might just end up in /outputs, for a more complex project,. probably /outputs/img
April 9, 2025 at 5:46 PM
depends on the project.
For a simple one, might just end up in /outputs, for a more complex project,. probably /outputs/img
For a simple one, might just end up in /outputs, for a more complex project,. probably /outputs/img