Stephen McAteer

Father of two, husband of one. Senior Manager, Data Science at the Victorian Auditor-General’s Office. PhD in mathematical physics. Long suffering Bombers supporter.

This blog is a showcase of data science work carried out by me and teams I’ve led … and a bunch of other random stuff besides.

data.gov.au maintains data on Australian Public holidays, but needs some massaging to get it into usable format. I wrote a cheap-and-nasty Python script for downloading and shaping the data into a more usable form. Click to view code.

The output is a single Pandas DataFrame in the following format:

  STATE DATE HOLIDAY_NAME INFORMATION MORE_INFORMATION
0 ACT 2015-01-01 New Year’s Day New Year’s Day is the first day of the calenda… NaN
1 ACT 2015-01-26 Australia Day Always celebrated on 26 January http://www.australiaday.org.au/
2 ACT 2015-04-03 Good Friday Easter is celebrated with Good Friday and East… NaN
… … … … … …

I said all I have to say about this in the code comments. :)

You May Also Enjoy

Plane tune

Concept: this project explores a novel sonification technique that combines: Parametric Path - A 2D curve defined as a function of time t, producing coor...

Financial audit dashboards

Each year, VAGO tables reports in Parliament summarizing the results of financial audits for various sectors, including local government and education. These...

Snooker scoreboard

A problem with being a snooker spectator is keeping track of whether a player has enough of a lead to have won the frame. You need to calulate the difference...