Skip to content

reachusama/uk-housing-analysis

Repository files navigation

UK Housing Price Analysis

Unlock the UK housing market’s hidden patterns — compare areas, track price trends, and spot the best opportunities for buying, selling, or investing.

https://data.police.uk/docs/ https://www.planning.data.gov.uk/dataset/flood-risk-zone https://beta-find-and-use-an-api.education.gov.uk/api/explore-education-statistics-api-1 https://explore-education-statistics.service.gov.uk/find-statistics?azsearch=true https://github.com/ONSdigital/address-index-data/blob/develop/DataScience/ProbabilisticParser/parser.py


📂 Getting Started

1. Download UK Housing Data

P.S: I am changing this to utilise optimal cloud storage, low-cost+high-speed query using free solutions to make it easy for users.

This dashboard does not ship with full data. You must manually download UK Price Paid Data from the official UK Government portal:

📎 Price Paid Data – GOV.UK

  • Choose CSV format
  • You can select individual months or the full historical archive [Note: App will not support full dataset.]
  • This tool supports any region, but the default demo shows Gloucestershire.

Once downloaded, upload the CSV via the "Upload dataset" section in the Streamlit sidebar.


2. Run the App

pip install -r requirements.txt
streamlit run app.py

🔍 What You Can Do With This Dashboard

This app is built for users interested in:

🏠 Buying a Home

  • See historical price trends in your target postcode or town
  • Understand seasonal patterns and local pricing mix
  • Compare Freehold vs Leasehold and New vs Old builds

📊 Selling or Valuing a Property

  • Track recent transactions in your street
  • Benchmark your home’s price vs nearby areas or similar property types
  • Spot outliers or unusual transactions near your address

📈 Property Investment

  • Use area rankings to find places with high median growth
  • Analyze repeat-sale returns to estimate typical resale performance
  • Run simple hedonic models to isolate the effect of size, tenure, and geography

💡 Tips for Using the Dashboard

  • Use date filters to focus on recent or historical windows
  • Enable winsorisation to remove the impact of extreme values
  • Read the caption under each section – they help explain how visuals work
  • Export charts and tables from the three-dot menu (⋮) in any block

TODO

  • Partition of EPC Certs Data for search and scale
  • Improve the PPD data by adding columns for search and scale
  • Create index for PPD & EPC
  • Create readme for data transformation, and upload to Huggingface
  • Create conversational app using agents to write query/code and execute via instances
  • Simplify communication/viz to only what supports user decision in uk housing investments
  • Re-write app to use duckdb and hugging face datasets
  • Migrate from public cloud to custom instance
  • Deploy project to custom domain
  • Create automation script for auto-sync of new data

Data Access URL

http://prod.publicdata.landregistry.gov.uk.s3-website-eu-west-1.amazonaws.com/pp-{year}.csv
https://epc.opendatacommunities.org/docs/guidance#field_domestic_NUMBER_HABITABLE_ROOMS
https://cloud.google.com/bigquery/public-data

About

A one-stop digital product for UK housing insights (under development).

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors