Once more ‘round the sun
Vague plans for the year ahead [Read more...]
Articles by John MacKintosh
The life changing magic of tidying text files
Bringing order to irregularly structured open data CSV files - with R, of course [Read more...]
Metallica tour history with R and PowerBI
Resolving errors connecting PowerBI to Linux version of MS SQL Server
Debugging "The target principal name is incorrect. Cannot generate SSPI context" error [Read more...]
new programming with data.table
baby steps creating handy functions with the new data.table programming interface [Read more...]
more .I in data.table
using .I and .N to retrieve the correct combination of records from grouped data [Read more...]
.I in data.table
A quick note to understand what .I does in data.table [Read more...]
non-equi joins in data.table
A quick note to understand (non-equi) joins in data.table [Read more...]
Newsletter news
TLDR - I've moved newsletter host, check your inbox /spam filters [Read more...]
Ph Profiles
why— layout: post title: That’s a (W)RAP! published: true date: 2023-12-06 image: path: /assets/img/blog/officer.png tags: rstats description: __ An ambition realised as a suite of R powered publications enter the public domain — [Read more...]
checks and {tiny}testing – a quick primer
A quick intro to checking and testing your functions, with help from {checkmate} and {tinytest}
Create your first Excel LAMBDA function
Here's how to create a set of custom, lambda functions in Excel. No macros or VBA required.
Achieve your target
A hands on, simple introduction to working with the {targets} package [Read more...]
Pivoting in tidyr and data.table
How to pivot data in data.table, compared to tidyr [Read more...]
Fixing my broken VSCode setup for R
Here's how I set up the correct user settings and keybindings for using R in VSCode [Read more...]
Making headlines
On target
Cover Up
Adding full sized cover images to Word documents programatically with officer, officedown, and purrr [Read more...]
Word Up – notes on working with Officer, Officedown and flextable to generate Word documents in RMarkdown
Producing Word documents in R is a scary thought, but there are packages to help. Here are some notes on the challenges I faced in my latest project at work, and how I resolved them with Officer, Officedown and flextable.
(h)appy with lapp(l)y
Want to modify or update multiple columns in rdatatable? Here's how, with lapply, and SDcols [Read more...]
Copyright © 2025 | MH Corporate basic by MH Themes