Menu

1 / 2

Street-level median house prices from HM Land Registry Price Paid Data in Python

DEV Community: datascience·Ashleigh Giles·2 days ago
#q6wlKRsx
#devtodatascience#science#devto#dev#street
Reading 0:00
15s threshold

To get street-level median house prices in England and Wales, download HM Land Registry Price Paid Data, filter by postcode prefix, group by street and take the median, keeping only streets with enough sales. This tutorial does it with pandas in under 20 lines, then shows why the result needs a minimum sample size and a property-type split.

I run Door Number , which publishes street-level tables built on this data. Checked on 8 November 2026.

What does the Price Paid Data file look like?

The yearly CSV files (pp-2019.csv to pp-2026.csv) have no header row. Each record has 16 fields, in this order: transaction ID, price, date of transfer, postcode, property type (D detached, S semi-detached, T terraced, F flat or maisonette, O other), old or new build (Y or N), tenure (F freehold, L leasehold), PAON (house number or name), SAON (flat number), street, locality, town or city, district, county, PPD category type (A or B) and record status (A added, C changed, D deleted).…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.