NHS Hospital Admissions Visualization

Project Overview

This project analyzes NHS hospital admissions by primary diagnosis category from 2020-21 to 2023-24.

It generates:

• A heatmap to compare admission volumes across years
• A treemap to show 2023-24 admission distribution and year-on-year percentage change (2022-23 to 2023-24)

The analysis is intended to highlight where admissions are concentrated and which diagnosis categories are rising or falling most quickly.

Data Scope

• Time range: 2020-21 to 2023-24
• Unit of analysis: ICD diagnosis categories (primary diagnosis summary)
• Core outputs include cross-year comparison, absolute and percentage changes between consecutive years, and top increases/decreases in admissions.

Environment

• Python: 3.11.9

Installation

Install dependencies from requirements.txt:

pip install -r requirements.txt

Run

python main.py

Output Files

Generated files are saved to:

NHS Hospital Admissions/output

Main outputs:

• merged_admissions.csv
• top_changes.csv
• report_summary.csv
• admissions_heatmap.png
• admissions_treemap.png