Once more ‘round the sun
Vague plans for the year ahead
Data By John
Getting things done with R, SQL, PowerBI and Excel.
Latest posts
The life changing magic of tidying text files
Bringing order to irregularly structured open data CSV files - with R, of course
new programming with data.table
baby steps creating handy functions with the new data.table programming interface
more .I in data.table
using .I and .N to retrieve the correct combination of records from grouped data
.I in data.table
A quick note to understand what .I does in data.table
non-equi joins in data.table
A quick note to understand (non-equi) joins in data.table
Newsletter news
TLDR - I've moved newsletter host, check your inbox /spam filters
That’s a W(RAP)!
An ambition realised as a suite of R powered publications enter the public domain
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.