UK Bank Holidays with Pandas on Jupyter

This post explains how to fetch and manipulate UK Bank Holidays JSON data using Pandas on a Jupyter Notebook to produce a queryable DataFrame.

• •The gov.uk bank holidays endpoint (https://www.gov.uk/bank-holidays.json) returns hierarchical JSON covering England/Wales, Scotland, and Northern Ireland
• •Pandas' json_normalize function is used to flatten nested JSON event arrays into a tabular DataFrame
• •Each column is explicitly typed with .astype() using string, datetime64[ns], and bool types
• •Date-range filtering is achieved via boolean masks or the more readable .query() syntax with @ variable references
• •The notebook was published on Kaggle after initial development on localhost Jupyter