census21api: a Python interface to the 2021 England and Wales Census

This repository contains the unofficial Python interface to the "Create a Custom Dataset" tool for the 2021 England and Wales Census. This interface was developed by the 2023 cohort of ONS (Office for National Statistics) Data Engineering and Architecture apprentices with support from the Data Science Campus.

The primary goal of this project is to simplify and streamline the process of accessing and working with 2021 England and Wales Census data.

The census21api package provides a core class, CensusAPI, through which users can interact with the Create a Custom Dataset API, enabling users to query tables and retrieve metadata in a programmatic way. It offers a more user-friendly and efficient way to work with the census data, particularly for data engineering and analysis tasks.

Getting Started

Installation

Currently, the census21api package is only installable through GitHub. We also require Python 3.8 or higher.

To install from GitHub via pip:

bash $ python -m pip install census21api@git+https://github.com/datasciencecampus/census21api

Or directly from source:

bash $ git clone https://github.com/datasciencecampus/census21api.git $ cd census21api $ python -m pip install .

Documentation

We have developed a full documentation site for the package, which is available at: datasciencecampus.github.io/census21api

Usage

Here's a basic example of how to use the CensusAPI class to retrieve a table:

```python

from census21api import CensusAPI

api = CensusAPI()

Specify a population type, area type, and some dimensions

See census21api.constants for a list of options

populationtype = "URHH" areatype = "ctry" dimensions = ("sex", "hhdeprivation_housing")

Submit the parameters to the table querist method

table = api.querytable(populationtype, areatype, dimensions) print(table) ctry sex hhdeprivationhousing count populationtype 0 E92000001 1 -8 0 URHH 1 E92000001 1 0 24993178 URHH 2 E92000001 1 1 3340293 URHH 3 E92000001 2 -8 0 URHH 4 E92000001 2 0 23890474 URHH 5 E92000001 2 1 3280355 URHH 6 W92000004 1 -8 0 URHH 7 W92000004 1 0 1457330 URHH 8 W92000004 1 1 100914 URHH 9 W92000004 2 -8 0 URHH 10 W92000004 2 0 1391731 URHH 11 W92000004 2 1 101574 URHH

```

[!TIP] If you encounter SSL verification issues, you can bypass this step by setting the verify parameter when creating an instance of CensusAPI: python api_unverified = CensusAPI(verify=False) In general, this is not recommended as SSL verification helps ensure the security of your machine and its connection to the internet. Please use this at your own discretion.

Limitations

The CensusAPI class includes a variety of methods to interact with the API in a very flexible way. However, there are still some limitations when compared with the web interface; these come from the API itself, which is still in development.

If you notice something wrong or something missing, consider making a contribution or opening an issue.

Blocked dimension combinations

Some combinations of columns (dimensions) cannot be queried at once. See #39 for an example. This is a deliberate block put in place by the developers of the API.

Some columns are missing

Despite the stringent statistical disclosure control all public ONS tables go through, some dimensions are not available in the API. For instance, you cannot query tables containing age data despite being able to create them through the web interface. Again, this is a deliberate choice by the developers and may be subject to change.

Contributing

This project is open-source, and contributions from the community are welcome. If you want to contribute to the project, please follow these steps:

1. Fork the repository and clone your fork.
2. Install the development dependencies for the package with python -m pip install -e ".[dev]".
3. Create your feature branch.
4. Make your changes, including writing property-based tests and documentation for your new feature.
5. Commit and push to the branch on your fork.
6. Open a pull request and request a review.

Please make sure to follow the project's coding standards and maintain a clean commit history for easier code review.

Contact

For questions, feedback, or inquiries about this project, please open an issue and we will get back to you as soon as possible.