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.

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.

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

About ** percent of home buyers in the United States in 2021 purchased homes that cost ******* U.S. dollars or more. The share of home buyers generally reduced as the house prices decreased. The largest share of purchases fell in the ******* to ******* and ******* to ******* price classes, which was below the national average sales price for existing homes.

This table shows the average purchase price that has been paid in the reporting period for existing own homes purchased by a private individual. The average purchase price of existing own homes may differ from the price index of existing own homes. The average purchase price is no indicator for price developments of owner-occupied residential property. The average purchase price reflects the average price of dwellings sold in a particular period. The fact that de dwellings sold differs from one period to another is not taken into account. The following instance explains which problems are entailed by the continually changing of the quality of the dwellings sold. Suppose in February of a particular year mainly big houses with extensive gardens beautifully situated alongside canals are sold, whereas in March many small terraced houses are sold. In that case the average purchase price in February will be higher than in March but this does not mean that house prices are increased. See note 3 for a link to the article 'Why the average purchase price is not an indicator'.

Data available from: 1995

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 average purchasing prices of existing owner-occupied sold homes can be calculated 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 17 February 2025: Added average purchase prices of the municipalities for the year 2024.

When will new figures be published? New figures are published approximately one to three months after the period under review.

Data description

The House Price Index (HPI) measures inflation in the residential property market. The HPI captures price changes of all types of dwellings purchased by households (flats, detached houses, terraced houses, etc.). Only transacted dwellings are considered, self-build dwellings are excluded. The land component of the dwelling is included.

The HPI is available for all European Union Member States (except Greece), the United Kingdom (only until the third quarter of 2020), Iceland, Norway, Switzerland and Turkey. In addition to the individual country series, Eurostat produces indices for the euro area and for the European Union (EU). As from the first quarter of 2020 onwards, the EU HPI aggregate no longer includes the HPI from the United Kingdom.

The national HPIs are produced by National Statistical Offices (NSIs) and the European aggregates by Eurostat, by combining the national indices. The data released quarterly on Eurostat's website include the national and European price indices, weights and their rates of change.

In order to provide a more comprehensive picture of the housing market, house sales indicators are also provided. Available house sales indicators refer to the total number and value of dwellings transactions at national level where the purchaser is a household. Eurostat publishes in its database a quarterly and annual house sales index as well as quarterly and annual rates of change.

Statistical concepts and definitions

The HPI is based on market prices of dwellings. Non-marketed prices are ruled out from the scope of this indicator. Self-build dwellings, dwellings purchased by sitting tenants at discount prices or dwellings transacted between family members are out of the scope of the indicator. It covers all monetary dwelling transactions regardless of its type (e.g., carried out through a cash purchase or financed through a mortgage loan).

The HPI measures the price developments of all dwellings purchased by households, regardless of which institutional sector they were bought from and the purpose of the purchase. As such, a dwelling bought by a household for a purpose other than owner-occupancy (e.g., for being rented out) is within the scope of the indicator. The HPI includes all purchases of new and existing dwellings, including those of dwellings transacted between households.

The number and value of house sales cover the total annual value of dwellings transactions at national level where the purchaser is a household. Transactions between households are included. Transfers in dwellings due to donations and inheritances are excluded.

The house sales value reflect the prices paid by household buyers and include both the price of land and the price of the structure of the dwelling. The prices for new dwellings include VAT. Other costs related to the acquisition of the dwelling (e.g., notary fees, registration fees, real estate agency commission, bank fees) are excluded.

Statistical unit

Each published index or rate of change refers to transacted dwellings purchased at market prices by the household sector in the corresponding geographical entity. All transacted dwellings are covered, regardless of which institutional sector they were bought from and of the purchase purpose.

more: https://ec.europa.eu/eurostat/cache/metadata/en/prc_hpi_inx_esms.htm

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.

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 ...

House Prices Dataset

Subtitle:

Detailed Real Estate Data for Predicting House Prices and Analyzing Market Trends

Description:

This dataset contains information on 21,613 properties, making it a comprehensive resource for exploring real estate market trends and building predictive models for house prices. The data includes various features capturing property details, location, and market conditions, providing ample opportunities for data exploration, visualization, and machine learning applications.

Key Features:

• General Information:

  • id: Unique identifier for each property.
  • date: Date of sale.

• Price Details:

  • price: Sale price of the house.

• Property Features:

  • bedrooms: Number of bedrooms.
  • bathrooms: Number of bathrooms (including partials as fractions).
  • sqft_living: Living space area in square feet.
  • sqft_lot: Lot size in square feet.
  • floors: Number of floors.
  • waterfront: Whether the property has a waterfront view.
  • view: Quality of the view rating.
  • condition: Overall condition of the house.
  • grade: Grade of construction and design (scale of 1–13).

• Additional Metrics:

  • sqft_above: Square footage of the property above ground.
  • sqft_basement: Basement area in square feet.
  • yr_built: Year the property was built.
  • yr_renovated: Year of last renovation.

• Location Coordinates:

  • zipcode: ZIP code of the property.
  • lat and long: Latitude and longitude coordinates.

• Neighbor Comparisons:

  • sqft_living15: Average living space of 15 nearest properties.
  • sqft_lot15: Average lot size of 15 nearest properties.

Use Cases:

• Predicting house prices using regression models.
• Identifying the impact of various features (e.g., number of bedrooms, location) on property prices.
• Analyzing market trends and spatial distribution of real estate prices.

This dataset is a valuable resource for anyone interested in real estate analytics, machine learning, or geographic data visualization.

The median purchase prices of residential property by Indian buyers in the United States generally increased between 2010 and 2024, with a significant drop in 2025. In 2025, Indian buyers paid a median price of ******* U.S. dollars for American properties. In the same year, Indian buyers purchased over ***** houses with a total value of *** billion U.S. dollars.

Single Family Home Prices in the United States increased to 415200 USD in October from 412300 USD in September of 2025. This dataset provides - United States Existing Single Family Home Prices- actual values, historical data, forecast, chart, statistics, economic calendar and news.

The median purchase prices of residential property by Mexican buyers in the United States generally increased between 2010 and 2025. In 2025, Mexican buyers paid a median price of ******* thousand U.S. dollars for American properties. In the same year, Mexican buyers purchased ***** houses with a total value of *** billion U.S. dollars.

Redfin is a real estate brokerage and publishes the US housing market data on a regular basis. Using this dataset, you can analyze and visualize housing market data for US cities. Timeline: Starting from February 2012 until the present time (Data is refreshed and updated on a monthly basis)

The dataset has the following columns: - period_begin - period_end - period_duration
- region_type
- region_type_id - table_id - is_seasonally_adjusted. (indicates if prices are seasonally adjusted; f represents False) - region - city - state - state_code - property_type - property_type_id - median_sale_price
- median_sale_price_mom (median sale price changes month over month) - median_sale_price_yoy (median sale price changes year over year) - median_list_price
- median_list_price_mom (median list price changes month over month) - median_list_price_yoy (median list price changes year over year) - median_ppsf (median sale price per square foot) - median_ppsf_mom (median sale price per square foot changes month over month) - median_ppsf_yoy (median sale price per square foot changes year over year) - median_list_ppsf (median list price per square foot) - median_list_ppsf_mom (median list price per square foot changes month over month) - median_list_ppsf_yoy. (median list price per square foot changes year over year) - homes_sold (number of homes sold) - homes_sold_mom (number of homes sold month over month) - homes_sold_yoy (number of homes sold year over year) - pending_sales
- pending_sales_mom
- pending_sales_yoy
- new_listings - new_listings_mom
- new_listings_yoy
- inventory - inventory_mom
- inventory_yoy
- months_of_supply
- months_of_supply_mom - months_of_supply_yoy
- median_dom (median days on market until property is sold) - median_dom_mom (median days on market changes month over month) - median_dom_yoy (median days on market changes year over year) - avg_sale_to_list (average sale price to list price ratio) - avg_sale_to_list_mom (average sale price to list price ratio changes month over month) - avg_sale_to_list_yoy (average sale price to list price ratio changes year over year) - sold_above_list
- sold_above_list_mom - sold_above_list_yoy - price_drops - price_drops_mom - price_drops_yoy - off_market_in_two_weeks (number of properties that will be taken off the market within 2 weeks) - off_market_in_two_weeks_mom (changes in number of properties that will be taken off the market within 2 weeks, month over month) - off_market_in_two_weeks_yoy (changes in number of properties that will be taken off the market within 2 weeks, year over year) - parent_metro_region - parent_metro_region_metro_code - last_updated

Filetype: gzip (gz) Support for gzip files in Python: https://docs.python.org/3/library/gzip.html

Data Source & Credit: Redfin.com

The median purchase prices of residential property by buyers from the United Kingdom in the United States fluctuated between 2010 to 2021. In 2021, buyers from the UK paid a median price of ******* thousand U.S. dollars for American properties.

View monthly updates and historical trends for US Existing Home Median Sales Price. from United States. Source: National Association of Realtors. Track ec…

This is the unadjusted median house priced for residential property sales (transactions) in the area for a 12 month period with April in the middle (year-ending September). These figures have been produced by the ONS (Office for National Statistics) using the Land Registry (LR) Price Paid data on residential dwelling transactions.

The LR Price Paid data are comprehensive in that they capture changes of ownership for individual residential properties which have sold for full market value and covers both cash sales and those involving a mortgage.

The median is the value determined by putting all the house sales for a given year, area and type in order of price and then selecting the price of the house sale which falls in the middle. The median is less susceptible to distortion by the presence of extreme values than is the mean. It is the most appropriate average to use because it best takes account of the skewed distribution of house prices.

Note that a transaction occurs when a change of freeholder or leaseholder takes place regardless of the amount of money involved and a property can transact more than once in the time period.

The LR records the actual price for which the property changed hands. This will usually be an accurate reflection of the market value for the individual property, but it is not always the case. In order to generate statistics that more accurately reflect market values, the LR has excluded records of houses that were not sold at market value from the dataset. The remaining data are considered a good reflection of market values at the time of the transaction. For full details of exclusions and more information on the methodology used to produce these statistics please see http://www.ons.gov.uk/peoplepopulationandcommunity/housing/qmis/housepricestatisticsforsmallareasqmi

The LR Price Paid data are not adjusted to reflect the mix of houses in a given area. Fluctuations in the types of house that are sold in that area can cause differences between the median transactional value of houses and the overall market value of houses. Therefore these statistics differ to the new UK House Price Index (HPI) which reports mix-adjusted average house prices and house price indices.

If, for a given year, for house type and area there were fewer than 5 sales records in the LR Price Paid data, the house price statistics are not reported. Data is Powered by LG Inform Plus and automatically checked for new data on the 3rd of each month.

Median Home Sale Price: All Residential: Crossville, TN data was reported at 201.000 USD th in Jul 2020. This records an increase from the previous number of 180.000 USD th for Jun 2020. Median Home Sale Price: All Residential: Crossville, TN data is updated monthly, averaging 146.000 USD th from Feb 2012 (Median) to Jul 2020, with 102 observations. The data reached an all-time high of 201.000 USD th in Jul 2020 and a record low of 97.000 USD th in Feb 2014. Median Home Sale Price: All Residential: Crossville, TN data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB056: Median Home Sale Price: by Metropolitan Areas.

Average House Prices in the United States increased to 534100 USD in August from 478200 USD in July of 2025. This dataset includes a chart with historical data for the United States New Home Average Sales Price.

Median Home Sale Price: All Residential: Bend, OR data was reported at 470.000 USD th in Jul 2020. This records an increase from the previous number of 430.000 USD th for Jun 2020. Median Home Sale Price: All Residential: Bend, OR data is updated monthly, averaging 331.000 USD th from Feb 2012 (Median) to Jul 2020, with 102 observations. The data reached an all-time high of 470.000 USD th in Jul 2020 and a record low of 170.000 USD th in Mar 2012. Median Home Sale Price: All Residential: Bend, OR data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB056: Median Home Sale Price: by Metropolitan Areas.