6 August 2018
Grabbing Australian public holiday data from data.gov.au
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. :)