HighlandR

Even Simpler SQL

Posted on June 3, 2018

I’ve had some feedback on the last post, and rather than repeat the same thing multiple times, I’m going all @drob, and writing this instead.. When I tweeted out the link to my post I gave it the tag line “why I’d rather write dplyr than SQL”. What I... [Read More]

simpler SQL with dplyr

comparing dplyr with SQL nested queries

Posted on June 1, 2018

Following on from my last post, where I demonstrated R to some first time R users, I want to do a wee comparison of dplyr V SQL, so that folks, particularly those in the NHS who might be R curious, can see just what the fuss is about. To... [Read More]

AphA Scotland - it's a thing

Reflections on AphA Scotland launch event

Posted on May 13, 2018

On Tues 8th May there was only one Scottish based member of the Association of Professional Healthcare Analysts (me) but on Wed 9th May that number rose to around 80 with the launch of the the Scotland AphA Branch. The event took place in the very nice Perth Concert... [Read More]

backed by data

Minimising risk of delayed departure

Posted on April 2, 2018

This post is an attempt to answer this question: https://community.rstudio.com/t/how-to-answer-a-question-without-statistical-tests-but-is-backed-by-data/3711 It was a pretty interesting question, and I had an initial stab at providing an answer, but the charts I submitted were not the best looking, shall we say ( it was a late night rush job). So, I’m going... [Read More]

No strings attached

a faceting function with bare variable names in ggplot2

Posted on March 4, 2018

I’m working on a package of dplyr and ggplot2 functions that I can use on a day to day basis to plot data over time. I’ve done some basic experimenting with my preferred ggplot2 theme settings (highlandrthemes - it’s a thing), and the next stage is to get some commonly... [Read More]

Theory free tidyeval

Getting our feet wet with dplyr programming

Posted on February 19, 2018

I’ve been putting off trying to suss out dplyr’s tidy evaluation for a long time, but I’ve been experimenting a bit with it so just making some notes here. It’s hard to talk about tidy evaluation / Non Standard Evaluation without getting into a whole load of theory, but I’m... [Read More]

Enter Sa(n)dMan

Posted on February 3, 2018

Yet more Metalliplots I’m just going to tidy up some issues from my last post where I did some tidytext analysis on the legendary rockers - Metallica. It was a fun way to pass some time and keep my hand in with text mining, something I still don’t seem... [Read More]

Hardwired..for tidy text

Posted on January 30, 2018

Song lyric and sentiment analysis for all So - a while back I did a tidy text analysis on Faith No More lyrics. I had thought about doing this with Metallica album lyrics, as they have had a long career, spanning their late teens/twenties to their 50’s. However,... [Read More]

Data Driven DIY

Hardwired...to Shelf Construct

Posted on January 20, 2018

Which fixing should I buy? I have a bathroom cabinet to put up. It needs to go onto a tiled plasterboard (drywall) wall. Because of the tiles, I can’t use the fixings I normally use to keep heavy objects fixed to the wall. And bog standard rawlplugs aren’t going... [Read More]

Time To Shine

Blogging and social media for introverts

Posted on December 30, 2017

How to spot an introvert You may have seen David Robinson’s recent post encouraging R users to start blogging. Some folk will willingly act on this advice, and others won’t. For those that won’t, I know who you are. You. Yes, you, trying to hide at the back.... [Read More]