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
Reposted by John MacKintosh
My A&E #warmingstripes experiments continue. Given that even the lowest value in this time series was 2,532 (Aug 2011), I don't think the colour gradient should start at blue, or even white; it should be shades of red all the way across.
The highest value was 212,280 (Dec 2022).
#rstats #ggplot2
The highest value was 212,280 (Dec 2022).
#rstats #ggplot2
May 26, 2025 at 1:28 PM
My A&E #warmingstripes experiments continue. Given that even the lowest value in this time series was 2,532 (Aug 2011), I don't think the colour gradient should start at blue, or even white; it should be shades of red all the way across.
The highest value was 212,280 (Dec 2022).
#rstats #ggplot2
The highest value was 212,280 (Dec 2022).
#rstats #ggplot2
Reposted by John MacKintosh
I need to acknowledge the significant advice I got from @johnmackintosh.bsky.social in my efforts to not compromise verisimilitude too much with this graph. (Guess what my new favourite word is.)
#verisimilitude #rstats #ggplot2
#verisimilitude #rstats #ggplot2
April 2, 2025 at 5:48 PM
I need to acknowledge the significant advice I got from @johnmackintosh.bsky.social in my efforts to not compromise verisimilitude too much with this graph. (Guess what my new favourite word is.)
#verisimilitude #rstats #ggplot2
#verisimilitude #rstats #ggplot2
Not going to win any awards but I'm quite pleased with this.
Firstly, it's my first dabble with shinylive.
Secondly, apart from shiny itself, it's all base R, no other packages.
I do need to brush up on my shiny layouts though..
#rstats
Firstly, it's my first dabble with shinylive.
Secondly, apart from shiny itself, it's all base R, no other packages.
I do need to brush up on my shiny layouts though..
#rstats
April 1, 2025 at 10:20 PM
Not going to win any awards but I'm quite pleased with this.
Firstly, it's my first dabble with shinylive.
Secondly, apart from shiny itself, it's all base R, no other packages.
I do need to brush up on my shiny layouts though..
#rstats
Firstly, it's my first dabble with shinylive.
Secondly, apart from shiny itself, it's all base R, no other packages.
I do need to brush up on my shiny layouts though..
#rstats
I have reverted my website from .net to .com
Old links should still work if you replace the domain.
Or maybe not, but just head over and I'm sure you'll find what you need.
johnmackintosh.com
Old links should still work if you replace the domain.
Or maybe not, but just head over and I'm sure you'll find what you need.
johnmackintosh.com
Welcome
Getting things done with R, SQL, PowerBI and Excel.
johnmackintosh.com
March 27, 2025 at 8:28 PM
I have reverted my website from .net to .com
Old links should still work if you replace the domain.
Or maybe not, but just head over and I'm sure you'll find what you need.
johnmackintosh.com
Old links should still work if you replace the domain.
Or maybe not, but just head over and I'm sure you'll find what you need.
johnmackintosh.com
Delighted to make it in among the highlights of the always excellent RWeekly and to hear my work being discussed on the podcast too.
Thanks guys @rpodcast.bsky.social
Thanks guys @rpodcast.bsky.social
Episode 195 of R Weekly Highlights is out! serve.podhome.fm/episodepage/...
📓 Monochrome visualisation @nrennie.bsky.social
🧹 Tidying census files @johnmackintosh.bsky.social
📱 Why Rlinguo? @colinfay.bsky.social
h/t @jonocarroll.fosstodon.org.ap.brid.gy & @mike-thomas.bsky.social 🙏
#RStats
📓 Monochrome visualisation @nrennie.bsky.social
🧹 Tidying census files @johnmackintosh.bsky.social
📱 Why Rlinguo? @colinfay.bsky.social
h/t @jonocarroll.fosstodon.org.ap.brid.gy & @mike-thomas.bsky.social 🙏
#RStats
Issue 2025-W07 Highlights
An illuminating set of tips for making the best out of the phrase "fifty shades of grey" in your next monochrome visualisation, how the unique formatting…
serve.podhome.fm
February 14, 2025 at 8:58 PM
Delighted to make it in among the highlights of the always excellent RWeekly and to hear my work being discussed on the podcast too.
Thanks guys @rpodcast.bsky.social
Thanks guys @rpodcast.bsky.social
#rstats
Anyone know of a way to download *all* your GitHub gists (including private ones) using the GitHub API or (?)R package?
Saw an old blog post that had a method bit it maxed out at 30 gists, and I have way more than that
Anyone know of a way to download *all* your GitHub gists (including private ones) using the GitHub API or (?)R package?
Saw an old blog post that had a method bit it maxed out at 30 gists, and I have way more than that
January 20, 2025 at 8:16 PM
#rstats
Anyone know of a way to download *all* your GitHub gists (including private ones) using the GitHub API or (?)R package?
Saw an old blog post that had a method bit it maxed out at 30 gists, and I have way more than that
Anyone know of a way to download *all* your GitHub gists (including private ones) using the GitHub API or (?)R package?
Saw an old blog post that had a method bit it maxed out at 30 gists, and I have way more than that
#rstats
I tidied up a bunch of horribly formatted open data CSV files so you don't have to.
A strategy for dealing with many irregularly dimensioned text files, featuring #rdatatable (obvs), #purrr, #arrow and #duckdb
johnmackintosh.net/blog/rstats/...
I tidied up a bunch of horribly formatted open data CSV files so you don't have to.
A strategy for dealing with many irregularly dimensioned text files, featuring #rdatatable (obvs), #purrr, #arrow and #duckdb
johnmackintosh.net/blog/rstats/...
The life changing magic of tidying text files
Bringing order to irregularly structured open data CSV files - with R, of course
johnmackintosh.net
December 22, 2024 at 10:40 PM
#rstats
I tidied up a bunch of horribly formatted open data CSV files so you don't have to.
A strategy for dealing with many irregularly dimensioned text files, featuring #rdatatable (obvs), #purrr, #arrow and #duckdb
johnmackintosh.net/blog/rstats/...
I tidied up a bunch of horribly formatted open data CSV files so you don't have to.
A strategy for dealing with many irregularly dimensioned text files, featuring #rdatatable (obvs), #purrr, #arrow and #duckdb
johnmackintosh.net/blog/rstats/...
Reposted by John MacKintosh
Please check it out, and feel free to share and let me know what you think!
jennajordan.me/blog/transfo...
jennajordan.me/blog/transfo...
The Transformation Flow, Part 1 - building intuition | Jenna Jordan
preparing to dive deeper into the flow of transformations in an analytical data warehouse
jennajordan.me
January 22, 2024 at 5:00 AM
Please check it out, and feel free to share and let me know what you think!
jennajordan.me/blog/transfo...
jennajordan.me/blog/transfo...
Reposted by John MacKintosh
I promised myself that with my website relaunch I would start writing more (and in particular writing about my work), so here's the first blog post to keep that promise: an introduction to analytical data warehouses
https://jennajordan.me/blog/analytical-data-warehouses
https://jennajordan.me/blog/analytical-data-warehouses
Analytical Data Warehouses - an introduction | Jenna Jordan
what? how? why? data warehousing for analytics, explained (mostly)
jennajordan.me
August 16, 2023 at 1:05 AM
I promised myself that with my website relaunch I would start writing more (and in particular writing about my work), so here's the first blog post to keep that promise: an introduction to analytical data warehouses
https://jennajordan.me/blog/analytical-data-warehouses
https://jennajordan.me/blog/analytical-data-warehouses
Two of the biggest misconceptions in #RStats
1. data.table is too hard to learn
2. It's only for really large datasets
Neither is true
1. data.table is too hard to learn
2. It's only for really large datasets
Neither is true
Some of my favorite new things with data.table in #rstats
(Ignore the CRAN not ok, we are working on some R C API changes still)
(Ignore the CRAN not ok, we are working on some R C API changes still)
October 26, 2024 at 8:45 AM
Two of the biggest misconceptions in #RStats
1. data.table is too hard to learn
2. It's only for really large datasets
Neither is true
1. data.table is too hard to learn
2. It's only for really large datasets
Neither is true
#RStats
Wondered why my notifications were going nuts over on Linkedin:
Yan Holtz's data-to-viz site is fantastic and I'm always pleased to see the reaction this plot gets.
www.linkedin.com/posts/yan-ho...
Incidentally, a "hot-take" in the replies was that this could have been a line chart. How?
Wondered why my notifications were going nuts over on Linkedin:
Yan Holtz's data-to-viz site is fantastic and I'm always pleased to see the reaction this plot gets.
www.linkedin.com/posts/yan-ho...
Incidentally, a "hot-take" in the replies was that this could have been a line chart. How?
Yan Holtz on LinkedIn: #dataviz | 18 comments
99% of time series data are represented with line charts 😳
Is it always the best choice?
Not sure!
➡️ Other chart types can sometimes be more appropriate:… | 18 comments on LinkedIn
www.linkedin.com
October 24, 2024 at 7:04 AM
#RStats
Wondered why my notifications were going nuts over on Linkedin:
Yan Holtz's data-to-viz site is fantastic and I'm always pleased to see the reaction this plot gets.
www.linkedin.com/posts/yan-ho...
Incidentally, a "hot-take" in the replies was that this could have been a line chart. How?
Wondered why my notifications were going nuts over on Linkedin:
Yan Holtz's data-to-viz site is fantastic and I'm always pleased to see the reaction this plot gets.
www.linkedin.com/posts/yan-ho...
Incidentally, a "hot-take" in the replies was that this could have been a line chart. How?
#RStats
Has anyone got a good workflow for collaborating on a Word document produced via Rmd (via {officedown})
Caveats : only one R user
Multiple SMEs
No git / source control
Many rounds of redrafts / changes as new requirements evolve
Changes are marked up by SMEs in Word via track changes
Has anyone got a good workflow for collaborating on a Word document produced via Rmd (via {officedown})
Caveats : only one R user
Multiple SMEs
No git / source control
Many rounds of redrafts / changes as new requirements evolve
Changes are marked up by SMEs in Word via track changes
October 22, 2024 at 3:34 PM
#RStats
Has anyone got a good workflow for collaborating on a Word document produced via Rmd (via {officedown})
Caveats : only one R user
Multiple SMEs
No git / source control
Many rounds of redrafts / changes as new requirements evolve
Changes are marked up by SMEs in Word via track changes
Has anyone got a good workflow for collaborating on a Word document produced via Rmd (via {officedown})
Caveats : only one R user
Multiple SMEs
No git / source control
Many rounds of redrafts / changes as new requirements evolve
Changes are marked up by SMEs in Word via track changes