dplyr

Well Well Well my Excel

I’m fed up forgetting how to combine lots of excel workbooks into one dataframe, so I’m documenting several ways of doing it, using purrr, data.table, rio and base R. Continue reading Well Well Well my Excel

Cutting down code in dplyr and data.table

Do we have to sacrifice readability for brevity? data.table allows succinct code, but so does tidyverse. data.table has some extra tricks up it’s sleeve though. Continue reading Cutting down code in dplyr and data.table

demystifying the coalesce function

coalesce is a one of those functions that might not strike you as being very useful, mainly because it doesn’t sound very exciting. But it IS useful, and might save you some time and complexity Continue reading demystifying the coalesce function

A wee look at group_map and group_split in dplyr

Even Simpler SQL

A follow up post, with improved SQL and dplyr code Continue reading Even Simpler SQL

simpler SQL with dplyr

comparing dplyr with SQL nested queries - and there is only one winner Continue reading simpler SQL with dplyr

AphA Scotland - it's a thing now

Reflections on AphA Scotland launch event Continue reading AphA Scotland - it's a thing now

backed by data

Minimising the risk of delayed departure with process control charts Continue reading backed by data

Theory free tidyeval

Getting our feet wet with dplyr programming and non standard evaluation Continue reading Theory free tidyeval

Let it flow, let it flow, let it flow......

Animating dot plots to demonstrate patient flow Continue reading Let it flow, let it flow, let it flow......

It's a dirty job, but someone's got to do it..

A tidytext analysis of Faith No More lyrics Continue reading It's a dirty job, but someone's got to do it..

Simply Mapping

Using the simple features package (sf), dplyr and ggplot2 to map Scottish Index of Multiple Deprivation (SIMD) 2016 data Continue reading Simply Mapping

let there be progress

The ‘wrapr’ package for use with dplyr programming Continue reading let there be progress

The hourly heatmap with ggplot2

How I made the 24/7 heatmap from my previous post with ggplot2, dplyr and lubridate Continue reading The hourly heatmap with ggplot2