Edmonton Residential Property Value Analysis
To start building coding skills, I enrolled in M2M Tech’s DataTalent program in late November 2025. For the first half of the program, I went through course content for data analysis, visualization, and an introduction to machine learning, and finished a capstone project in January 2026. We could choose to analyze any open data set and apply the course content, and I ended up selecting data from the City of Edmonton’s open data sets. I chose data on property values for 2025 because, as someone who lives here, I was curious to see the spread of residential values across the city.
Edmonton's residential real estate market encompasses diverse neighborhoods with varying property characteristics and values. My project analyzes property assessment data to see if there are answers to these questions: What factors most strongly correlate with property values? Which neighborhoods have the highest and lowest home values? How are properties distributed across different price ranges?
Using Python and data visualization libraries, I conducted a comprehensive analysis of over 400,000 residential property records, and recorded a presentation of what I found. All of the code that I commented for this analysis can be found here.
First Steps.
In Google CoLab, I imported the Pandas, NumPy, and Bokeh libraries. Then to prepare and clean the data, I checked for missing values, converted numerical columns, removed outliers and rows with missing assessed values, and filtered the data for residential properties only.
Basic Statistics and Percentiles.
10th
$15,500.00
25th
$185,000.00
50th/Median
$367,500.00
75th
$490,000.00
90th
$632,500.00
95th
$757,500.00
99th
$1,236,500.00
Mean
$370,925.80
Median
$367,500.00
Standard Deviation
$308,491.59
Minimum
$500.00
Maximum
$25,361,500.00
Neighbourhood Statistics.
Top 10 Most Expensive Neighbourhoods (by Mean Value)
Top 10 Least Expensive Neighbourhoods (by Mean Value)
Ward Statistics.
Most Expensive Ward (by mean value)
Pihêsiwin & Ipiihkoohkanipiaohtsi
Least Expensive Ward (by mean value)
O-day'min
Visualizations.
Takeaways & Questions.
•Most property values are below $500k, showing that Edmonton has a lot of affordable housing opportunities
•There are property values below $100k spread around Edmonton
•Properties greater than $700k are also spread around Edmonton, but largely in the southwest and central areas
•There’s no strong correlation between Assessed Values and other data that was collected
This raises questions:
•If low property values can be quite spread around Edmonton, could this be dragging down values of other properties?
•What does strongly correlate to the property values around the city?
There could be other data collected by the city that shows what affects residential property values, but from this data set, we can at least see that Edmonton has plenty of affordable housing. Ultimately, more data needs to be collected and analyzed for homeowners, city planners, and real estate professionals to make their respective decisions. Data-driven planning at the city level in particular guides resilient development and community investment for all Edmontonians, ideally for their benefit.