Advertisement ยท 728 ร— 90

Posts by John MacKintosh

Yeah pretty sure ease of access / updating and portability was behind this. If I remember correctly, the day I demoted this I had to make some changes (like, an hour beforehand) and being able to just tweak the yaml and run it was much easier that rooting through individual files.
Would do it again

1 month ago 1 0 0 0
Preview
GitHub - johnmackintosh/scodas-dbexplorer: loop over database tables using dynamic SQL via R, and and display results in shiny app loop over database tables using dynamic SQL via R, and and display results in shiny app - johnmackintosh/scodas-dbexplorer

This kind of thing?
github.com/johnmackinto...
I stored server and table names in yaml config file, then used those to loop through the database tables, return data and populate shiny app.
It's in the generate_app_data script (I think).

1 month ago 3 0 1 0
Post image

๐Ÿ“ฆ medicalcoder v0.8.0 is now on CRAN.

medicalcoder is a unified and longitudinally aware framework for ICD-based comorbidity assessment in #rstats

CRAN: cran.r-project.org/package=medi...

GitHub: github.com/dewittpe/med...

Website: peteredewitt.com/medicalcoder/

1 month ago 12 4 1 0

Was your prompt "get this package to a state I'm happy with, in just a few lines of code"?
Awesome, I was actually looking at this on GitHub a week or so ago and noticed some activity. Will be brilliant to have this on CRAN as I have absolutely had it with annotating plots via trial & error

2 months ago 4 0 2 0

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 ๐Ÿ˜

6 months ago 5 0 0 0
Preview
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

Clubcard FTW

8 months ago 1 0 0 0

I've just accidentally scanned this in Tesco. Cost me ยฃ2.99

8 months ago 1 0 1 0
Advertisement

Wait - are these not there for you?

10 months ago 1 0 1 0

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.

11 months ago 3 0 1 0
Consume
Consume YouTube video by The Warning - Topic

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)

11 months ago 7 0 2 0

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

11 months ago 6 0 1 0

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

11 months ago 6 0 3 0

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)

1 year ago 5 0 1 0

Glad to be of help @kurtstat.bsky.social and amazing to see that you will be discussing this at EdinbR later this month ๐Ÿ‘

1 year ago 2 0 0 0
Shiny App

You can interact with this at
johnmackintosh.github.io/small-area-shiny/

Yes, I should have thought of a better name

#rstats

1 year ago 0 0 0 0
Advertisement

Thanks @brodriguesco.bsky.social
I will share later

I hope y"all spotted the reverse psychology:
"Not going to win any awards.."
and I fully expect to be nominated for everything, including, but not limited to, chart of the year, plot of the decade, and graphic of the century.

1 year ago 2 0 1 0
Screenshot of a shiny app with a population pyramid. The app allows selection of one of thirteen geographical boundaries.
There are dark blue bars on the left of the pyramid representing counts of males, in five year age bands from 0 to 90+
Light blue bars represent counts of females.

Screenshot of a shiny app with a population pyramid. The app allows selection of one of thirteen geographical boundaries. There are dark blue bars on the left of the pyramid representing counts of males, in five year age bands from 0 to 90+ Light blue bars represent counts of females.

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

1 year ago 25 3 2 0

Facets might prove useful also.
I think I played around with transparency at the time but , as you discovered, it doesn't work..

1 year ago 1 0 1 0

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

1 year ago 9 1 0 0

At least you got rid of the unnecessary gridlines...(one of my pet peeves is when I see any form of process control chart with extraneous gridlines on it)

grey / amber / blue ?

1 year ago 1 0 2 0

Brilliant, thanks.

1 year ago 1 0 0 0

#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

1 year ago 0 0 2 0
Advertisement

www.manning.com/books/beyond...

I really like this book, fills in a lot of gaps that aren't addressed elsewhere, including R4DS.

1 year ago 1 0 0 0
Preview
GitHub - MilesMcBain/capsule: An inversion of renv for low effort reproducible R package libraries An inversion of renv for low effort reproducible R package libraries - MilesMcBain/capsule


You might like to look at {capsule).

renv was a headache for me on a Windows network share, although it is fine (relatively) on local drive.

Depending on the scale of the project, capsule might be worth your time

github.com/MilesMcBain/...

1 year ago 2 0 0 0

Thanks Christian. I think / hope I've been usurped since then ๐Ÿ˜„

1 year ago 1 0 1 0

I've built pretty much every main chart type in PowerBI, including xmr-s, and Laney corrected U-charts, but not in a position to share any of that just yet. There are some good add-ins for PBI already though.

1 year ago 1 0 0 0

Just checked that link to xmrit, and find links to my work in Qlik (and my spccharter R package, which is still a bit of WIP)

These things must come and go in cycles. When I learned about them, it was "nothing new" & healthcare was seen as lagging behind industry. Now many resources are from h/c

1 year ago 2 0 1 0

Imagine you have a lot of data that is related, and should be in a database / data warehouse, but isn't, and likely won't ever be (for whatever reason)

Create your own database locally with duckdb. Bonus, write dplyr code for querying it (via duckplyr)

1 year ago 13 0 1 0

I remember being OK with ggplot2, but struggling with data manipulation on a daily basis (I was still up to my neck in Excel and also learning SQL at the same time.
When dplyr first came out, it was like someone finally turned the lights on.

1 year ago 4 0 0 0

group_by() behaviour in dplyr has changed a few times over the years. I wanted to piece together a history of what changed and when, and the feedback that got it to its current position (I remember "peeling off of layers" causing some angst).
I never got round to it, but would be interesting..

1 year ago 2 0 0 0
Advertisement