« R 3.4.3 released | Main | Because it's Friday: The Whole of the Moon »

December 01, 2017


Feed You can follow this conversation by subscribing to the comment feed for this post.

I agree with your assessment of ABS spreadsheets in general. There are even more things that are annoying, like changes made by hand with different releases.

However in this case you may be slightly at fault. I say slightly because it's not obvious. I had not looked at the survey results. When I did I noticed that it was disseminated using ABSStat.

This means you have a choice for the format of your data. You could have saved it as a csv file. What is not obvious is that unlike the Excel format it does not retain the structure of the data, but flattens it. Also you have to choose the csv string option. So no not really your fault.

Hey Tom,
They might have been produced by the ABSStat system but they don't appear to be accessible from there as far as I can tell.

I got them from this page: https://marriagesurvey.abs.gov.au/results/downloads.html

Right now xlsx is the only available option.

Hi Miles,
The AMLPS data is on ABS.Stat and available via REST web service call or csv export under "Snapshots of Australia | Australian Marriage Law Postal Survey". This was also released on the 15th.

It would be interesting to see your clean-up and Census combination work using this data source.

The comments to this entry are closed.

Search Revolutions Blog

Got comments or suggestions for the blog editor?
Email David Smith.
Follow revodavid on Twitter Follow David on Twitter: @revodavid
Get this blog via email with Blogtrottr