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

December 01, 2017

Comments

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.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Your Information

(Name and email address are required. Email address will not be displayed with the comment.)

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
‚Äč