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.

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.

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.

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

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.

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.

A commonly accepted threshold for affordable housing costs at the household level is 30% of a household's income. Accordingly, a household is considered cost burdened if it pays more than 30% of its income on housing. Households paying more than 50% are considered severely cost burdened. These thresholds apply to both homeowners and renters.

The Housing Affordability indicator only measures cost burden among the region's households, and not the supply of affordable housing. The directionality of cost burden trends can be impacted by changes in both income and housing supply. If lower income households are priced out of a county or the region, it would create a downward trend in cost burden, but would not reflect a positive trend for an inclusive housing market.

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.

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

Global house prices experienced a significant shift in 2022, with advanced economies seeing a notable decline after a prolonged period of growth. The real house price index (adjusted for inflation) for advanced economies peaked at nearly *** index points in early 2022 before falling to around ***** points by the second quarter of 2023. In the second quarter of 2025, the index reached ***** points. This represents a reversal of the upward trend that had characterized the housing market for roughly a decade. Likewise, real house prices in emerging economies declined after reaching a high of ***** points in the third quarter of 2021. What is behind the slowdown? Inflation and slow economic growth have been the primary drivers for the cooling of the housing market. Secondly, the growing gap between incomes and house prices since 2012 has decreased the affordability of homeownership. Last but not least, homebuyers in 2024 faced dramatically higher mortgage interest rates, further contributing to worsening sentiment and declining transactions. Some markets continue to grow While many countries witnessed a deceleration in house price growth in 2022, some markets continued to see substantial increases. Turkey, in particular, stood out with a nominal increase in house prices of over ** percent in the first quarter of 2025. Other countries that recorded a two-digit growth include North Macedonia and Russia. When accounting for inflation, the three countries with the fastest growing residential prices in early 2025 were North Macedonia, Portugal, and Bulgaria.

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.

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.

Portugal, Canada, and the United States were the countries with the highest house price to income ratio in 2024. In all three countries, the index exceeded 130 index points, while the average for all OECD countries stood at 116.2 index points. The index measures the development of housing affordability and is calculated by dividing nominal house price by nominal disposable income per head, with 2015 set as a base year when the index amounted to 100. An index value of 120, for example, would mean that house price growth has outpaced income growth by 20 percent since 2015. How have house prices worldwide changed since the COVID-19 pandemic? House prices started to rise gradually after the global financial crisis (2007–2008), but this trend accelerated with the pandemic. The countries with advanced economies, which usually have mature housing markets, experienced stronger growth than countries with emerging economies. Real house price growth (accounting for inflation) peaked in 2022 and has since lost some of the gain. Although, many countries experienced a decline in house prices, the global house price index shows that property prices in 2023 were still substantially higher than before COVID-19. Renting vs. buying In the past, house prices have grown faster than rents. However, the home affordability has been declining notably, with a direct impact on rental prices. As people struggle to buy a property of their own, they often turn to rental accommodation. This has resulted in a growing demand for rental apartments and soaring rental prices.

In this Economic Commentary , we compare characteristics of the 2000–2006 house-price boom that preceded the Great Recession to the house-price boom that began in 2020 during the COVID-19 pandemic. These two episodes of high house-price growth have important differences, including the behavior of rental rates, the dynamics of housing supply and demand, and the state of the mortgage market. The absence of changes in fundamentals during the 2000s is consistent with the literature emphasizing house-price beliefs during this prior episode. In contrast to during the 2000s boom, changes in fundamentals (including rent and demand growth) played a more dominant role in the 2020s house-price boom.

The house price-to-income ratio in the United States has reached concerning levels, with the index hitting ***** in the second quarter of 2025. This indicates that house prices have outpaced income growth by *****percent since 2015, highlighting a growing affordability crisis in the housing market. The widening gap between home prices and wages is putting homeownership out of reach for many Americans, particularly as real wages have remained stagnant. Rising home prices and stagnant wages While average annual real wages in the United States have increased slightly since 2014, home prices have soared. The median sales price of existing single-family homes reached a record-high in 2024, representing a substantial increase over the past five years. This disparity between wage growth and home price appreciation has led to a significant decrease in housing affordability across the country. Affordability challenges in the U.S. housing market The U.S. Housing Affordability Index, which measures whether a family earning the median income can afford a median-priced home, plummeted in 2024, marking the second-worst year for homebuyers since records began. This decline in affordability is reflected in homebuyer sentiment, with homebuyer sentiment plummeting.

Description:

This dataset contains prices of New York houses, providing valuable insights into the real estate market in the region. It includes information such as broker titles, house types, prices, number of bedrooms and bathrooms, property square footage, addresses, state, administrative and local areas, street names, and geographical coordinates.

Key Features:

• BROKERTITLE: Title of the broker
• TYPE: Type of the house
• PRICE: Price of the house
• BEDS: Number of bedrooms
• BATH: Number of bathrooms
• PROPERTYSQFT: Square footage of the property
• ADDRESS: Full address of the house
• STATE: State of the house
• MAIN_ADDRESS: Main address information
• ADMINISTRATIVE_AREA_LEVEL_2: Administrative area level 2 information
• LOCALITY: Locality information
• SUBLOCALITY: Sublocality information
• STREET_NAME: Street name
• LONG_NAME: Long name
• FORMATTED_ADDRESS: Formatted address
• LATITUDE: Latitude coordinate of the house
• LONGITUDE: Longitude coordinate of the house

Potential Use Cases:

• Price analysis: Analyze the distribution of house prices to understand market trends and identify potential investment opportunities.
• Property size analysis: Explore the relationship between property square footage and prices to assess the value of different-sized houses.
• Location-based analysis: Investigate geographical patterns to identify areas with higher or lower property prices.
• Bedroom and bathroom trends: Analyze the impact of the number of bedrooms and bathrooms on house prices.
• Broker performance analysis: Evaluate the influence of different brokers on the pricing of houses.

If you find this dataset useful, your support through an upvote would be greatly appreciated ❤️🙂 Thank you

This dataset provides insights into the global housing market, covering various economic factors from 2015 to 2024. It includes details about property prices, rental yields, interest rates, and household income across multiple countries. This dataset is ideal for real estate analysis, financial forecasting, and market trend visualization.

📑 Column Descriptions

Graph and download economic data for Real Residential Property Prices for United States (QUSR628BIS) from Q1 1970 to Q2 2025 about residential, HPI, housing, real, price index, indexes, price, and USA.

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.