https://raw.githubusercontent.com/Masterx-AI/Project_Housing_Price_Prediction_/main/hs.jpg" alt="">

Description:

A simple yet challenging project, to predict the housing price based on certain factors like house area, bedrooms, furnished, nearness to mainroad, etc. The dataset is small yet, it's complexity arises due to the fact that it has strong multicollinearity. Can you overcome these obstacles & build a decent predictive model?

Acknowledgement:

Harrison, D. and Rubinfeld, D.L. (1978) Hedonic prices and the demand for clean air. J. Environ. Economics and Management 5, 81–102. Belsley D.A., Kuh, E. and Welsch, R.E. (1980) Regression Diagnostics. Identifying Influential Data and Sources of Collinearity. New York: Wiley.

Objective:

• Understand the Dataset & cleanup (if required).
• Build Regression models to predict the sales w.r.t a single & multiple feature.
• Also evaluate the models & compare thier respective scores like R2, RMSE, etc.

House Price Prediction Dataset.

The dataset contains 2000 rows of house-related data, representing various features that could influence house prices. Below, we discuss key aspects of the dataset, which include its structure, the choice of features, and potential use cases for analysis.

1. Dataset Features

The dataset is designed to capture essential attributes for predicting house prices, including:

Area: Square footage of the house, which is generally one of the most important predictors of price. Bedrooms & Bathrooms: The number of rooms in a house significantly affects its value. Homes with more rooms tend to be priced higher. Floors: The number of floors in a house could indicate a larger, more luxurious home, potentially raising its price. Year Built: The age of the house can affect its condition and value. Newly built houses are generally more expensive than older ones. Location: Houses in desirable locations such as downtown or urban areas tend to be priced higher than those in suburban or rural areas. Condition: The current condition of the house is critical, as well-maintained houses (in 'Excellent' or 'Good' condition) will attract higher prices compared to houses in 'Fair' or 'Poor' condition. Garage: Availability of a garage can increase the price due to added convenience and space. Price: The target variable, representing the sale price of the house, used to train machine learning models to predict house prices based on the other features.

2. Feature Distributions

Area Distribution: The area of the houses in the dataset ranges from 500 to 5000 square feet, which allows analysis across different types of homes, from smaller apartments to larger luxury houses. Bedrooms and Bathrooms: The number of bedrooms varies from 1 to 5, and bathrooms from 1 to 4. This variance enables analysis of homes with different sizes and layouts. Floors: Houses in the dataset have between 1 and 3 floors. This feature could be useful for identifying the influence of multi-level homes on house prices. Year Built: The dataset contains houses built from 1900 to 2023, giving a wide range of house ages to analyze the effects of new vs. older construction. Location: There is a mix of urban, suburban, downtown, and rural locations. Urban and downtown homes may command higher prices due to proximity to amenities. Condition: Houses are labeled as 'Excellent', 'Good', 'Fair', or 'Poor'. This feature helps model the price differences based on the current state of the house. Price Distribution: Prices range between $50,000 and $1,000,000, offering a broad spectrum of property values. This range makes the dataset appropriate for predicting a wide variety of housing prices, from affordable homes to luxury properties.

3. Correlation Between Features

A key area of interest is the relationship between various features and house price: Area and Price: Typically, a strong positive correlation is expected between the size of the house (Area) and its price. Larger homes are likely to be more expensive. Location and Price: Location is another major factor. Houses in urban or downtown areas may show a higher price on average compared to suburban and rural locations. Condition and Price: The condition of the house should show a positive correlation with price. Houses in better condition should be priced higher, as they require less maintenance and repair. Year Built and Price: Newer houses might command a higher price due to better construction standards, modern amenities, and less wear-and-tear, but some older homes in good condition may retain historical value. Garage and Price: A house with a garage may be more expensive than one without, as it provides extra storage or parking space.

4. Potential Use Cases

The dataset is well-suited for various machine learning and data analysis applications, including:

House Price Prediction: Using regression techniques, this dataset can be used to build a model to predict house prices based on the available features. Feature Importance Analysis: By using techniques such as feature importance ranking, data scientists can determine which features (e.g., location, area, or condition) have the greatest impact on house prices. Clustering: Clustering techniques like k-means could help identify patterns in the data, such as grouping houses into segments based on their characteristics (e.g., luxury homes, affordable homes). Market Segmentation: The dataset can be used to perform segmentation by location, price range, or house type to analyze trends in specific sub-markets, like luxury vs. affordable housing. Time-Based Analysis: By studying how house prices vary with the year built or the age of the house, analysts can derive insights into the trends of older vs. newer homes.

5. Limitations and ...

The number of U.S. home sales in the United States declined in 2024, after soaring in 2021. A total of four million transactions of existing homes, including single-family, condo, and co-ops, were completed in 2024, down from 6.12 million in 2021. According to the forecast, the housing market is forecast to head for recovery in 2025, despite transaction volumes expected to remain below the long-term average. Why have home sales declined? The housing boom during the coronavirus pandemic has demonstrated that being a homeowner is still an integral part of the American dream. Nevertheless, sentiment declined in the second half of 2022 and Americans across all generations agreed that the time was not right to buy a home. A combination of factors has led to house prices rocketing and making homeownership unaffordable for the average buyer. A survey among owners and renters found that the high home prices and unfavorable economic conditions were the two main barriers to making a home purchase. People who would like to purchase their own home need to save up a deposit, have a good credit score, and a steady and sufficient income to be approved for a mortgage. In 2022, mortgage rates experienced the most aggressive increase in history, making the total cost of homeownership substantially higher. Are U.S. home prices expected to fall? The median sales price of existing homes stood at 413,000 U.S. dollars in 2024 and was forecast to increase slightly until 2026. The development of the S&P/Case Shiller U.S. National Home Price Index shows that home prices experienced seven consecutive months of decline between June 2022 and January 2023, but this trend reversed in the following months. Despite mild fluctuations throughout the year, home prices in many metros are forecast to continue to grow, albeit at a much slower rate.

Graph and download economic data for Median Sales Price of Houses Sold for the United States (MSPUS) from Q1 1963 to Q2 2025 about sales, median, housing, and USA.

The average sales price of new homes in the United States experienced a slight decrease in 2024, dropping to 512,2000 U.S. dollars from the peak of 521,500 U.S. dollars in 2022. This decline came after years of substantial price increases, with the average price surpassing 400,000 U.S. dollars for the first time in 2021. The recent cooling in the housing market reflects broader economic trends and changing consumer sentiment towards homeownership. Factors influencing home prices and affordability The rapid rise in home prices over the past few years has been driven by several factors, including historically low mortgage rates and increased demand during the COVID-19 pandemic. However, the market has since slowed down, with the number of home sales declining by over two million between 2021 and 2023. This decline can be attributed to rising mortgage rates and decreased affordability. The Housing Affordability Index hit a record low of 98.1 in 2023, indicating that the median-income family could no longer afford a median-priced home. Future outlook for the housing market Despite the recent cooling, experts forecast a potential recovery in the coming years. The Freddie Mac House Price Index showed a growth of 6.5 percent in 2023, which is still above the long-term average of 4.4 percent since 1990. However, homebuyer sentiment remains low across all age groups, with people aged 45 to 64 expressing the most pessimistic outlook. The median sales price of existing homes is expected to increase slightly until 2025, suggesting that affordability challenges may persist in the near future.

Australian Housing Prices

Location, Size, Price, Etc

By Jeff [source]

About this dataset

This dataset contains information on 1000 properties in Australia, including location, size, price, and other details

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

If you're looking for a dataset on Australian housing data, this is a great option. This dataset contains information on over 1000 properties in Australia, including location, size, price, and other details. With this data, you can answer questions like What is the average price of a home in Australia?, What are the most popular type of homes in Australia?, and more

Research Ideas

• This dataset can be used to predict hosing prices in Australia.
• This dataset can be used to find relationships between housing prices and location.
• This dataset can be used to find relationships between housing prices and features such as size, number of bedrooms, and number of bathrooms

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: RealEstateAU_1000_Samples.csv | Column name | Description | |:--------------------|:---------------------------------------------------------------------------------------| | breadcrumb | A breadcrumb is a text trail that shows the user's location within a website. (String) | | category_name | The name of the category that the listing belongs to. (String) | | property_type | The type of property being listed. (String) | | building_size | The size of the property's building, in square meters. (Numeric) | | land_size | The size of the property's land, in square meters. (Numeric) | | preferred_size | The preferred size of the property, in square meters. (Numeric) | | open_date | The date that the property was first listed for sale. (Date) | | listing_agency | The agency that is listing the property. (String) | | price | The listing price of the property. (Numeric) | | location_number | The number that corresponds to the property's location. (Numeric) | | location_type | The type of location that the property is in. (String) | | location_name | The name of the location that the property is in. (String) | | address | The property's address. (String) | | address_1 | The first line of the property's address. (String) | | city | The city that the property is located in. (String) | | state | The state that the property is located in. (String) | | zip_code | The zip code that the property is located in. (String) | | phone | The listing agent's phone number. (String) | | latitude | The property's latitude. (Numeric) | | longitude | The property's longitude. (Numeric) | | product_depth | The depth of the product. (Numeric) | | bedroom_count | The number of bedrooms in the property. (Numeric) | | bathroom_count | The number of bathrooms in the property. (Numeric) | | parking_count | The number of parking spaces in the property. (Numeric) | | RunDate | The date that the listing was last updated. (Date) |

Acknowledgements

If you use this dataset in your research, please credit the original authors. If you use this dataset in your research, please credit Jeff.

Graph and download economic data for All-Transactions House Price Index for the United States (USSTHPI) from Q1 1975 to Q3 2025 about appraisers, HPI, housing, price index, indexes, price, and USA.

Reference: https://www.zillow.com/research/zhvi-methodology/

Official Background

In setting out to create a new home price index, a major problem Zillow sought to overcome in existing indices was their inability to deal with the changing composition of properties sold in one time period versus another time period. Both a median sale price index and a repeat sales index are vulnerable to such biases (see the analysis here for an example of how influential the bias can be). For example, if expensive homes sell at a disproportionately higher rate than less expensive homes in one time period, a median sale price index will characterize this market as experiencing price appreciation relative to the prior period of time even if the true value of homes is unchanged between the two periods.

The ideal home price index would be based off sale prices for the same set of homes in each time period so there was never an issue of the sales mix being different across periods. This approach of using a constant basket of goods is widely used, common examples being a commodity price index and a consumer price index. Unfortunately, unlike commodities and consumer goods, for which we can observe prices in all time periods, we can’t observe prices on the same set of homes in all time periods because not all homes are sold in every time period.

The innovation that Zillow developed in 2005 was a way of approximating this ideal home price index by leveraging the valuations Zillow creates on all homes (called Zestimates). Instead of actual sale prices on every home, the index is created from estimated sale prices on every home. While there is some estimation error associated with each estimated sale price (which we report here), this error is just as likely to be above the actual sale price of a home as below (in statistical terms, this is referred to as minimal systematic error). Because of this fact, the distribution of actual sale prices for homes sold in a given time period looks very similar to the distribution of estimated sale prices for this same set of homes. But, importantly, Zillow has estimated sale prices not just for the homes that sold, but for all homes even if they didn’t sell in that time period. From this data, a comprehensive and robust benchmark of home value trends can be computed which is immune to the changing mix of properties that sell in different periods of time (see Dorsey et al. (2010) for another recent discussion of this approach).

For an in-depth comparison of the Zillow Home Value Index to the Case Shiller Home Price Index, please refer to the Zillow Home Value Index Comparison to Case-Shiller

Each Zillow Home Value Index (ZHVI) is a time series tracking the monthly median home value in a particular geographical region. In general, each ZHVI time series begins in April 1996. We generate the ZHVI at seven geographic levels: neighborhood, ZIP code, city, congressional district, county, metropolitan area, state and the nation.

Underlying Data

Estimated sale prices (Zestimates) are computed based on proprietary statistical and machine learning models. These models begin the estimation process by subdividing all of the homes in United States into micro-regions, or subsets of homes either near one another or similar in physical attributes to one another. Within each micro-region, the models observe recent sale transactions and learn the relative contribution of various home attributes in predicting the sale price. These home attributes include physical facts about the home and land, prior sale transactions, tax assessment information and geographic location. Based on the patterns learned, these models can then estimate sale prices on homes that have not yet sold.

The sale transactions from which the models learn patterns include all full-value, arms-length sales that are not foreclosure resales. The purpose of the Zestimate is to give consumers an indication of the fair value of a home under the assumption that it is sold as a conventional, non-foreclosure sale. Similarly, the purpose of the Zillow Home Value Index is to give consumers insight into the home value trends for homes that are not being sold out of foreclosure status. Zillow research indicates that homes sold as foreclosures have typical discounts relative to non-foreclosure sales of between 20 and 40 percent, depending on the foreclosure saturation of the market. This is not to say that the Zestimate is not influenced by foreclosure resales. Zestimates are, in fact, influenced by foreclosure sales, but the pathway of this influence is through the downward pressure foreclosure sales put on non-foreclosure sale prices. It is the price signal observed in the latter that we are attempting to measure and, in turn, predict with the Zestimate.

Market Segments Within each region, we calculate the ZHVI for various subsets of homes (or mar...

The median sales price of new homes sold in the United States increased steadily from 1965 to 2022, followed by two years of decline. In 2024, a newly built home cost approximately ******* U.S. dollars. That was a decline from the peak price of 434,500 U.S. dollars in 2022. Prices varied greatly across different regions in the country, with the most expensive housing found in the Northeast region.

House prices grew year-on-year in most states in the U.S. in the first quarter of 2025. Hawaii was the only exception, with a decline of **** percent. The annual appreciation for single-family housing in the U.S. was **** percent, while in Rhode Island—the state where homes appreciated the most—the increase was ******percent. How have home prices developed in recent years? House price growth in the U.S. has been going strong for years. In 2025, the median sales price of a single-family home exceeded ******* U.S. dollars, up from ******* U.S. dollars five years ago. One of the factors driving house prices was the cost of credit. The record-low federal funds effective rate allowed mortgage lenders to set mortgage interest rates as low as *** percent. With interest rates on the rise, home buying has also slowed, causing fluctuations in house prices. Why are house prices growing? Many markets in the U.S. are overheated because supply has not been able to keep up with demand. How many homes enter the housing market depends on the construction output, whereas the availability of existing homes for purchase depends on many other factors, such as the willingness of owners to sell. Furthermore, growing investor appetite in the housing sector means that prospective homebuyers have some extra competition to worry about. In certain metros, for example, the share of homes bought by investors exceeded ** percent in 2025.

Key information about House Prices Growth

• US house prices grew 3.3% YoY in Sep 2025, following an increase of 4.1% YoY in the previous quarter.
• YoY growth data is updated quarterly, available from Mar 1992 to Sep 2025, with an average growth rate of -12.4%.
• House price data reached an all-time high of 17.7% in Sep 2021 and a record low of -12.4% in Dec 2008.

In 2022, house price growth in the UK slowed, after a period of decade-long increase. Nevertheless, in June 2025, prices reached a new peak, with the average home costing ******* British pounds. This figure refers to all property types, including detached, semi-detached, terraced houses, and flats and maisonettes. Compared to other European countries, the UK had some of the highest house prices. How have UK house prices increased over the last 10 years? Property prices have risen dramatically over the past decade. According to the UK house price index, the average house price has grown by over ** percent since 2015. This price development has led to the gap between the cost of buying and renting a property to close. In 2023, buying a three-bedroom house in the UK was no longer more affordable than renting one. Consequently, Brits have become more likely to rent longer and push off making a house purchase until they have saved up enough for a down payment and achieved the financial stability required to make the step. What caused the recent fluctuations in house prices? House prices are affected by multiple factors, such as mortgage rates, supply, and demand on the market. For nearly a decade, the UK experienced uninterrupted house price growth as a result of strong demand and a chronic undersupply. Homebuyers who purchased a property at the peak of the housing boom in July 2022 paid ** percent more compared to what they would have paid a year before. Additionally, 2022 saw the most dramatic increase in mortgage rates in recent history. Between December 2021 and December 2022, the **-year fixed mortgage rate doubled, adding further strain to prospective homebuyers. As a result, the market cooled, leading to a correction in pricing.

The U.S. housing market has slowed, after ** consecutive years of rising home prices. In 2021, house prices surged by an unprecedented ** percent, marking the highest increase on record. However, the market has since cooled, with the Freddie Mac House Price Index showing more modest growth between 2022 and 2024. In 2024, home prices increased by *** percent. That was lower than the long-term average of *** percent since 1990. Impact of mortgage rates on homebuying The recent cooling in the housing market can be partly attributed to rising mortgage rates. After reaching a record low of **** percent in 2021, the average annual rate on a 30-year fixed-rate mortgage more than doubled in 2023. This significant increase has made homeownership less affordable for many potential buyers, contributing to a substantial decline in home sales. Despite these challenges, forecasts suggest a potential recovery in the coming years. How much does it cost to buy a house in the U.S.? In 2023, the median sales price of an existing single-family home reached a record high of over ******* U.S. dollars. Newly built homes were even pricier, despite a slight decline in the median sales price in 2023. Naturally, home prices continue to vary significantly across the country, with West Virginia being the most affordable state for homebuyers.

The number of home sales in the United States peaked in 2021 at almost ************* after steadily rising since 2018. Nevertheless, the market contracted in the following year, with transaction volumes falling to ***********. Home sales remained muted in 2024, with a mild increase expected in 2025 and 2026. A major factor driving this trend is the unprecedented increase in mortgage interest rates due to high inflation. How have U.S. home prices developed over time? The average sales price of new homes has also been rising since 2011. Buyer confidence seems to have recovered after the property crash, which has increased demand for homes and also the prices sellers are demanding for homes. At the same time, the affordability of U.S. homes has decreased. Both the number of existing and newly built homes sold has declined since the housing market boom during the coronavirus pandemic. Challenges in housing supply The number of housing units in the U.S. rose steadily between 1975 and 2005 but has remained fairly stable since then. Construction increased notably in the 1990s and early 2000s, with the number of construction starts steadily rising, before plummeting amid the infamous housing market crash. Housing starts slowly started to pick up in 2011, mirroring the economic recovery. In 2022, the supply of newly built homes plummeted again, as supply chain challenges following the COVID-19 pandemic and tariffs on essential construction materials such as steel and lumber led to prices soaring.

In 2025, Turkey had the highest inflation-adjusted house price index out of the ** European countries under observation, making it the country where house prices have increased the most since 2010. In Turkey, the house price index exceeded *** index points in the second quarter of 2025, showing an increase in real terms of *** percent since 2010, the baseline year for the index. Iceland and Hungary completed the top three, with an index value of *** and *** index points. In the past year, however, many European countries saw house prices decline in real terms. Where can I find other metrics on different housing markets in Europe? To assess the valuation in different housing markets, one can compare the house-price-to-income ratios of different countries worldwide. These ratios are calculated by dividing nominal house prices by nominal disposable income per head. There are also ratios that look at how residential property prices relate to domestic rents, such as the house-price-to-rent ratio for the United Kingdom. Unfortunately, these numbers are not available in a European overview. An overview of the price per square meter of an apartment in the EU-28 countries is available, however. One region, different markets An important trait of the European housing market is that there is not one market, but multiple. Property policy in Europe lies with the domestic governments, not with the European Union. This leads to significant differences between European countries, which shows in, for example, the homeownership rate (the share of owner-occupied dwellings of all homes). These differences also lead to another problem: the availability of data. Non-Europeans might be surprised to see that house price statistics vary in depth, as every country has their own methodology and no European body exists that tracks this data for the whole continent.

This dataset contains data on all Real Property parcels that have sold since 2013 in Allegheny County, PA.

Before doing any market analysis on property sales, check the sales validation codes. Many property "sales" are not considered a valid representation of the true market value of the property. For example, when multiple lots are together on one deed with one price they are generally coded as invalid ("H") because the sale price for each parcel ID number indicates the total price paid for a group of parcels, not just for one parcel. See the Sales Validation Codes Dictionary for a complete explanation of valid and invalid sale codes.

Sales Transactions Disclaimer: Sales information is provided from the Allegheny County Department of Administrative Services, Real Estate Division. Content and validation codes are subject to change. Please review the Data Dictionary for details on included fields before each use. Property owners are not required by law to record a deed at the time of sale. Consequently the assessment system may not contain a complete sales history for every property and every sale. You may do a deed search at http://www.alleghenycounty.us/re/index.aspx directly for the most updated information. Note: Ordinance 3478-07 prohibits public access to search assessment records by owner name. It was signed by the Chief Executive in 2007.

Existing Home Sales in the United States increased to 4100 Thousand in October from 4050 Thousand in September of 2025. This dataset provides the latest reported value for - United States Existing Home Sales - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

The figures of existing own homes are related to the stock of existing own homes. Besides the price indices, figures are also published about the numbers sold, the average purchase price, and the total sum of the purchase prices of the sold dwellings. The House Price Index of existing own homes is based on a complete registration of sales of dwellings by the Dutch Land Registry Office (Kadaster) and the (WOZ) value of all dwellings in the Netherlands. Indices may fluctuate, for example if a small number of dwellings are sold in a certain region. In such cases we recommended using the long-term figures. The average purchase price of existing own homes may differ from the price index of existing own homes. The change in the average purchase price, however, is not an indicator for price developments of existing own homes.

Data available from: 1st quarter 1995 to 4th quarter 2023

Status of the figures: The figures in this table are immediately definitive. The calculation of these figures is based on the number of notary transactions that are registered every month by the Dutch Land Registry Office (Kadaster). A revision of the figures is exceptional and occurs specifically if an error significantly exceeds the acceptable statistical margins. The numbers of existing owner-occupied sold homes can be recalculated by Kadaster at a later date. These figures are usually the same as the publication on Statline, but in some periods they differ. Kadaster calculates the average purchasing prices based on the most recent data. These may have changed since the first publication. Statistics Netherlands uses figures from the first publication in accordance with the revision policy described above.

Changes as of 6 June 2024: This table has been discontinued. This table is followed by Existing own homes; purchase prices, price index 2020=100, region. See paragraph 3.

From reporting period 2024 quarter 1, the base year of the House Price Index for Existing Dwellings (PBK) will be adjusted from 2015 to 2020. In April 2024, the first figures of this new series will be released. These figures will be available in a new StatLine table. The old series (base year = 2015) can still be consulted via StatLine, but will no longer be updated.

The U.S. housing market continues to evolve, with the median price for existing homes forecast to fall to ******* U.S. dollars by 2027. This projection comes after a period of significant growth and recent fluctuations, reflecting the complex interplay of economic factors affecting the real estate sector. The rising costs have not only impacted home prices but also down payments, with the median down payment more than doubling since 2012. Regional variations in housing costs Home prices and down payments vary dramatically across the United States. While the national median down payment stood at approximately ****** U.S. dollars in early 2024, homebuyers in states like California, Massachusetts, and Hawaii faced down payments exceeding ****** U.S. dollars. This disparity highlights the challenges of homeownership in high-cost markets and underscores the importance of location in determining housing affordability. Market dynamics and future outlook The housing market has shown signs of cooling after years of rapid growth, with a modest price increase of *** percent in 2024. This slowdown can be attributed in part to rising mortgage rates, which have tempered demand. Despite these challenges, most states continued to see year-over-year price growth in 2025, with Rhode Island and West Virginia leading the packby home appreciation. As the market adjusts to new economic realities, potential homebuyers and investors alike will be watching closely for signs of stabilization or renewed growth in the coming years.