ABS 2021 Mesh Block dwelling counts to CSV (code and data)

As of 31 August 2022, the Australian Bureau of Statistics has only released the 2021 census Mesh Block dwelling counts as an Excel file, with data stratified across 12 worksheets. This is inconvenient for users who wish to link this data with digital boundaries, and not useful for data posterity. In addition to completing a feedback survey for the ABS, suggesting that a CSV download should be provided (which the Excel file itself suggests is the case in its Explanatory Notes, and was the case with the 2011 and 2016 census releases), I thought it would be useful to take the time to compile these and make them public for myself and others until an official release is produced. 
This repository contains the code to combine the 12 worksheets into a single national CSV file, as well as state-stratified CSV files of Mesh Block dwelling and person counts, along with the resulting data outputs.   
The code is also published in a Jupyter Notebook at https://github.com/carlhiggs/abs_mesh_block_counts_csv/blob/main/ABS Mesh Block counts to CSV.ipynb
Users of the data should note, "Cells ... have been randomly adjusted to avoid the release of confidential data.".  The data is © Commonwealth of Australia 2022, and data was made available by the Australian Bureau of Statistics under a Creative Commons Attribution 4.0 International licence as per https://www.abs.gov.au/website-privacy-copyright-and-disclaimer#copyright-and-creative-commons.

截至2022年8月31日，澳大利亚统计局（Australian Bureau of Statistics, ABS）仅发布了2021年人口普查网格块（Mesh Block）住宅数量的Excel文件，该数据按12个工作表分层存储。这对于希望将该数据与数字地理边界进行关联的用户而言极不便利，也不利于数据的长期留存。除了向澳大利亚统计局提交反馈问卷，建议提供CSV格式下载（该Excel文件的"说明注释"中也提及可提供此格式，且2011年与2016年的人口普查发布版本均支持CSV下载）之外，我认为花时间整理这些数据并公开分享，无论对我自己还是其他用户，在官方发布正式版本前都颇具价值。
本代码仓库包含将12个工作表合并为单份全国性CSV文件的代码，同时也包含按州分层的网格块住宅与人口数量CSV文件，以及最终生成的数据输出结果。
该代码同时以Jupyter Notebook形式发布于：https://github.com/carlhiggs/abs_mesh_block_counts_csv/blob/main/ABS Mesh Block counts to CSV.ipynb
使用本数据的用户需注意："部分单元格已进行随机调整，以避免泄露保密数据。" 本数据版权归澳大利亚联邦政府2022年所有，由澳大利亚统计局依据《知识共享署名4.0国际许可协议》发布，详情参见：https://www.abs.gov.au/website-privacy-copyright-and-disclaimer#copyright-and-creative-commons

搜集汇总

背景与挑战

背景概述

该数据集提供了将澳大利亚统计局2021年人口普查的Mesh Block住宅计数从Excel转换为CSV格式的代码和结果数据，便于与数字边界数据链接和长期保存。数据包含全国性和按州分层的CSV文件，适用于城市分析和土地利用规划研究。