tidyr
Posts featuring tidyr
fwf without the faff
Fixed width files aren’t too common, but they don’t have to be scary. readr comes to the rescue with read_fwf() Continue reading fwf without the faff
Calculating hotel occupancy with R
Putting patientcounter to the test by calculating hotel occupancy. Continue reading Calculating hotel occupancy with R
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
Introducing popthemes
Introducing another set of palettes and scales for ggplot2, based on pop album covers. Continue reading Introducing popthemes
Some data.table tips
Rolling joins, wrapping functions around regular DT[] calls, and more. Continue reading Some data.table tips
Scheduled Refresh - a surprisingly simple fix
Scheduled Refresh wasn’t working on our server, despite the correct credentials being supplied with the correct account and privileges. The fix was simple, but not particularly obvious. Continue reading Scheduled Refresh - a surprisingly simple fix
PreppinData - accepting the challenge with R and PowerBI
I’ve completed a month of ‘PreppinData’ challenges, using both R and PowerBI. Some things have been easy, some have not - here’s what I’ve learned in Week 1 Continue reading PreppinData - accepting the challenge with R and PowerBI
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
collapse might rock your world
collapse is a new force in the data transformation stakes. In this post, I try out one simple function and compare it to data.table and dplyr Continue reading collapse might rock your world
NHS-R Community Conference 2020
The 3rd Annual NHS-R Community Conference went virtual, and was an amazing success. Although I missed plenty, I saw more than enough good stuff to know that this is my team. And, everything’s online for catch up. Yay! Continue reading NHS-R Community Conference 2020
Defending the indefensible
The UK Government Coronavirus briefing on Saturday caused all sorts of consternation. Not least, the graphics that were presented in support of further lockdown. What happened, how bad was it really, and what could be improved? Continue reading Defending the indefensible
Getting started with network plots
Network plots can be hit or miss. For those of us used to tables or dataframes, the terminology is confusing. They often don’t look good. However, the visNetwork package changes all that as it greatly simplifies the process of producing useful, interactive network plots. Continue reading Getting started with network plots
The day after
Spreadsheets find themselves in the news for all the wrong reasons. Is R’s time in healthcare now? Continue reading The day after
Rapid Analysis and Presentation of Quality Improvement Data with R
I presented at RMedicine2020 and really enjoyed it Continue reading Rapid Analysis and Presentation of Quality Improvement Data with R
Solving small data problems with data.table
Friday afternoon fun - how do we do this apparently simple thing? Continue reading Solving small data problems with data.table
SIMD Revisited
Visualising the updated Scottish Index of Multiple Deprivation data without maps. Continue reading SIMD Revisited
patientcounter
Introducing the patientcounter package for tracking moves between locations Continue reading patientcounter
Programming with data.table
getting started with multiple bare variable names in data.table functions. Continue reading Programming with data.table
data.table by a dummy
A dummies guide to the fabulous data.table package. Continue reading data.table by a dummy
A wee look at group_map and group_split in dplyr
Continue reading A wee look at group_map and group_split in dplyr
gganimation for the nation
gganimate is now on CRAN so taking it for a test drive Continue reading gganimation for the nation
Automatic (slides) for the people
Creating and saving multiple plots to Powerpoint Continue reading Automatic (slides) for the people
Where am I?
Notes on the here package Continue reading Where am I?
Mid Table Mediocrity
Visualising potential winners and promotion prospects in the Scottish Championship Continue reading Mid Table Mediocrity
More tidy evaluation with ggplot2
Another look at tidy evaluation with a slight twist on the previous post Continue reading More tidy evaluation with ggplot2
Tidily evaluated ggplot2
Test driving tidy evaluation in the new release of ggplot2 Continue reading Tidily evaluated ggplot2
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
No strings attached
creating a faceting function with bare variable names in ggplot2 Continue reading No strings attached
Theory free tidyeval
Getting our feet wet with dplyr programming Continue reading Theory free tidyeval
Enter Sa(n)dMan
Yet more Metallica sentiment analysis - wrapping up the last post with additional plots. Continue reading Enter Sa(n)dMan
Hardwired..for tidy text
using the genius and tidytext packages to peform a sentiment analysis of Metallica’s song lyrics over time Continue reading Hardwired..for tidy text
Data Driven DIY - Hardwired...to Shelf Construct
Yes, I’m blogging about drilling a hole in the wall. Send help.. Continue reading Data Driven DIY - Hardwired...to Shelf Construct
Time To Shine
Blogging and social media for introverts - it CAN be done Continue reading Time To Shine
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..
Mapping to a 't'(map)
the tmap package <- beautiful static and interactive maps with R Continue reading Mapping to a 't'(map)
Simply Mapping
Using the simple features package 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 Run(chart)ing Man
Measurement for improvement in healthcare with R and Qlik Continue reading The Run(chart)ing Man
R to the Rescue
A strategy for gathering scattered spreadsheet data with R Continue reading R to the Rescue
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
Daily metric tracking with ggplot2
Calendar style plots for multiple metrics over the same period with ggplot2 Continue reading Daily metric tracking with ggplot2
F is for Forecast
First steps with time series and prediction in R Continue reading F is for Forecast
Chart MakeoveR
Working out and restyling a chart with (geom) dumbbells Continue reading Chart MakeoveR
ggExtra is Extra useful
Amending scales on ggplots with easy to remember syntax Continue reading ggExtra is Extra useful
