β€ͺAll lit up for #WorldPancreaticCancerDay‬ a whole day in advance

Finance fixed their data and broke my case study

The past few years, I’ve delivered an introduction to using R workshop that relied on manipulating Ministry of Finance demographic projections.

Analyzing these data was a great case study for the typical data management process. The data was structured for presentation, rather than analysis. So, there were several header rows, notes at the base of the table, and the data was spread across many worksheets.

Finance’s table structure

Sometime recently, the ministry released an update that provides the data in a much better format: one sheet with rows for age and columns for years. Although this is a great improvement, I’ve had to update my case study, which makes it actually less useful as a lesson in data manipulation.

Although I’ve updated the main branch of the github repository, I’ve also created a branch that sources the archive.org version of the page from October 2016. Now, depending on the audience, I can choose the case study that has the right level of complexity.

Despite briefly causing me some trouble, I think it is great that these data are closer to a good analytical format. Now, if only the ministry could go one more step towards tidy data and make my case study completely unecessary.

Organizing

Sack of candy

Scarecrow and the ninja

Apple picking

A happy cross country runner

A workflow for leaving the office

Sometimes it’s the small things, accumulated over many days, that make a difference. As a simple example, every day when I leave the office, I message my family to let them know I’m leaving and how I’m travelling. Relatively easy: just open the Messages app, find the most recent conversation with them, and type in my message.

Using Workflow I can get this down to just a couple of taps on my watch. By choosing the “Leaving Work” workflow, I get a choice of travelling options:

Leaving work from the Apple Watch

Choosing one of them creates a text with the right emoticon that is pre-addressed to my family. I hit send and off goes the message.

The workflow itself is straightforward:

Leaving work workflow

Like I said, pretty simple. But saves me close to a minute each and every day.

Another tribute to Labrador and Newfoundland dogs