Exploring your database with shiny
Several of my recent blog posts have been focussed on using {purrr} and {glue} to programatically query a database. [Read more...]
Articles by John MacKintosh
Situation
You want to run a query over multiple tables in your database / warehouse and then process and visualise the combined results of those queries. You need to be able to switch between servers, databases, schemas and tables, selecting different columns and applying different conditions in the WHERE clause. You don’... [Read more...]
Dynamic schema, table and column names in SQL Server queries as a gateway to functional programming with R
I’m looking into creating some functions to make it easier to carry out quality checks on our database tables. I’m using SQL Server, where tables are referred to in a [database].[schema].[tablename] format, although you can forgo some of this by using the USE statement - [Read more...]
Dual axis charts – how to make them and why they can be useful
I had to produce a dual axis chart as part of a piece of work transitioning an Excel report to markdown.
Getting to know Julia
I thought I’d try Julia out and see how far I could get with nothing but Google on my side.
Separate SQL
Inverness street maps
Taras Kaduk produced a beautiful street map here and I decided to try it, but for Inverness.
What song lyric sentiment analysis doesn’t tell you
This is an exercise in trying out the rolldown package. [Read more...]
sankey_test
```r library(data.table) library(dplyr) library(tidyr) library(networkD3) library(htmlwidgets) library(widgetframe) data [Read more...]
UK Energy company acquisitions – a great use case for Sankey plots
Like many others in the ‘United’ Kingdom, I’ve found my energy supplier has gone bust, due to ongoing price hikes, and I’ve been moved over to another one, whom ordinarily I wouldn’t have signed up with.
Enjoying the process of making tables in R using {reactable} and {reactablefmtr}
I recently had to recreate a report which was originally produced in Excel. This is currently being converted to pdf and emailed out each morning. Initially I was thinking that a flexdashboard solution would be called for, but on seeing the report it was mainly tables, which the audience liked, ...
I invented something better than wordclouds. True or False?
I got my first package onto CRAN, and YOU CAN TOO
It’s almost 2 weeks since I had my first package successfully submitted to CRAN. The runcharter package is special to me for lots of reasons - it was a tough problem to crack, and it’s one I’ve worked on with a variety of tools over the years. If ... [Read more...]
Shooting Stars
cusumcharter available on CRAN
I submitted my cusumcharter package to CRAN late last Friday evening and was pleasantly surprised to receive an email early on Monday advising me it was on its way to CRAN.
Scheduling Rmarkdown files on Windows – your foolproof guide
You’ve written a great rmarkdown file, and now you want to run it at a set time every day. You’ve tried the Windows Task Scheduler, you’ve pointed it at your markdown file, and you’ve gone off to make some coffee safe in the knowledge that your ...
Pass parameter to SQL Server DATEADD function using R
I wanted to try and create some parameters in my flexdashboard script, so I could extract data from our warehouse over a flexible date range. [Read more...]
fwf without the faff
Calculating hotel occupancy with R
I saw a question on reddit today which can be answered using {patientcounter} [Read more...]
Well Well Well my Excel
Importing multiple excel files (not sheets, but files) and flattening into one data frame / tibble / data.table should be straightforward - shouldn’t it? How many ways can there be? [Read more...]
Copyright © 2025 | MH Corporate basic by MH Themes