dplyr
Posts featuring dplyr.

Importing multiple Excel files
Ways to combine multiple excel workbooks into one dataframe, using purrr, data.table, rio and base R. Continue reading Importing multiple Excel files

Cutting down code in dplyr and data.table
Optimising code in data.table and tidyverse. Continue reading Cutting down code in dplyr and data.table

demystifying the coalesce function
coalesce is one of the most useful functions that you’re probably not using. Want to find the first non NA value from one or more vectors? You need coalesce Continue reading demystifying the coalesce function

A wee look at group_map and group_split in dplyr
Continue reading A wee look at group_map and group_split in dplyrEven 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......
Visualising patient flow with animated dotplots 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) to map Scottish Index of Multiple Deprivation (SIMD) 2016 data Continue reading Simply Mapping

The hourly heatmap with ggplot2
A 24/7 timeseries heatmap with ggplot2, dplyr and lubridate Continue reading The hourly heatmap with ggplot2