Project – Housing Price Analysis

housing_price

In economic analysis, it’s crucial to understand how the local economy is doing. This means looking at important factors like job growth, GDP trends, and how much people are spending. A strong housing market usually happens when the economy is doing well, making these factors really important.

At the same time, it’s vital to know what people want in the market. Are there lots of people wanting to buy houses, or are houses being sold quickly? Understanding these trends helps us figure out what buyers and sellers are looking for in the housing market.

Additionally, where a house is located is super important. We need to consider the neighborhood’s safety, the quality of schools, and how close it is to important places like shops and parks. All of these factors play a big role in how much people are willing to pay for a home, creating a sort of “melody” that attracts potential buyers.

Dataset year range: 2022 – Housing Price Analysis. 

Columns:

Price: The price of the house.
Area: The total area of the house in square feet.
Bedrooms: The number of bedrooms in the house.
Bathrooms: The number of bathrooms in the house.
Stories: The number of stories in the house.
Mainroad: Whether the house is connected to the main road (Yes/No).
Guestroom: Whether the house has a guest room (Yes/No).
Basement: Whether the house has a basement (Yes/No).
Hot water heating: Whether the house has a hot water heating system (Yes/No).
Airconditioning: Whether the house has an air conditioning system (Yes/No).
Parking: The number of parking spaces available within the house.
Prefarea: Whether the house is located in a preferred area (Yes/No).
Furnishing status: The furnishing status of the house (Fully Furnished, Semi-Furnished, Unfurnished).

Data Source: kaggle.com

Software/Programming Languages Used:

  • Power BI
  • Python
  • Excel
average_price_2
Average_price_by_area
average_price_unit_area
Average_price_of_hotwater_mainroad_housing
Average_price_of_number_bedrooms_housing
average_price_furnishingstatus_bedrooms
Average_price_of_mainroad_bathrooms_housing

Connect to the main road:
The 19.95% increase in the price of housing differs between properties connected to the main road and those with or without hot water heating.

No connection to the main road:
The 6.09% increase in the price of housing differs between properties connected to the main road and those with or without hot water heating.

1-bathroom:
The 13.98% increase in the price of housing differs between properties with 1 bathroom and those with or without hot water heating.

2-bathrooms:
The 3.63% increase in the price of housing differs between properties with 2 bathrooms and those with or without hot water heating.

3-bathrooms:
The 38% increase in the price of housing differs between properties with 3 bathrooms and those with or without hot water heating.

4-bathrooms:
There is no data for 4-bathrooms having hot water heating in this dataset, so it cannot calculate the rate.

Average_price_of_parking_airconditioning_housing

1-car parking:
The 0.82% increase in the price of housing differs between properties with 1 car parking and those with or without hot water heating.

2-car parking:
The 25.10% increase in the price of housing differs between properties with 2-car parking and those with or without hot water heating.

3-car parking:
There is no data for 3-car parking having hot water heating in this dataset, so it cannot calculate the rate.

No Parking:
The 8.74% increase in the price of housing differs between properties without parking and those with or without hot water heating.

Average_price_of_prefarea_stories_housing

Having preferred area:
The rate of increase of 3.92% in the price of housing differs between properties with preferred area and those with and without hot water heating.

No preferred area:
The rate of increase of 25.64% in the price of housing differs between properties with preferred area and those with and without hot water heating.

1-stories:
The rate of increase of 7.65% in the price of housing differs between properties with 1-stories and those with and without hot water heating.

2-stories:
The rate of increase of 31.35% in the price of housing differs between properties with 2 stories and those with and without hot water heating.

3-stories:
The rate of increase of -5.45% in the price of housing differs between properties with 3 stories and those with and without hot water heating.

4-stories:
There is no data for 4 stories having hot water heating in this dataset, so it cannot calculate the rate.

Average_price_of_basement_guestroom_housing

Having basement:
The rate of increase of 29.05% in the price of housing differs between properties with a basement and those with and without hot water heating.

No basement:
The rate of increase of 9.87% in the price of housing differs between properties without a basement and those with and without hot water heating.

Having guestroom:
The rate of increase of 13.36% in the price of housing differs between properties with a guestroom and those with and without hot water heating.

No guestroom:
The rate of increase of 19.35% in the price of housing differs between properties without guestroom and those with and without hot water heating.

 

Disclaimer for Data Analysis and Data Science

** The purpose of creating this Data Analysis and Data Science is solely for educational use, and any commercial use is strictly prohibited.

This disclaimer (“Disclaimer”) is provided to inform users of the data analysis and data science findings (“Analysis”) that the following terms and conditions govern its use. By accessing and using the Analysis, you acknowledge and agree to the terms set forth herein. If you do not agree with these terms, please do not use the Analysis.

1. Purpose and Nature of the Analysis

The Analysis is intended exclusively for informational and analytical purposes. It is not intended as professional advice, and it should not be considered as a substitute for expert consultation or guidance in specific areas of expertise. The Analysis is a representation of data at a particular point in time and should not be interpreted as a definitive source of information.

2. Data Accuracy and Limitations

The data used in the Analysis is sourced from various publicly available or authorized data sets and may be subject to inaccuracies, errors, or omissions. Users are advised to independently verify any critical information or data points presented in the Analysis. The Analysis may also involve assumptions and simplifications that can impact the accuracy and comprehensiveness of the results.

The results of this analysis may be subject to limitations, assumptions, and uncertainties inherent to the data sources, methods, and models employed. Any decisions or actions taken based on the information in this analysis are the sole responsibility of the user, and we disclaim any liability for the consequences of such decisions or actions.

3. User Responsibility

Any decisions, actions, or interpretations made based on the Analysis are solely the responsibility of the user. We disclaim any liability for the consequences of such decisions or actions. Users should exercise caution and critical judgment when utilizing the Analysis to inform any course of action.

4. Data Privacy and Ethical Considerations

Users must respect data privacy and ethical principles when conducting their own analyses or using information presented in the Analysis. Ensure that you have the necessary permissions and adhere to all applicable laws and regulations when handling and analyzing data, particularly when working with sensitive or personal data.

5. No Warranty

We make no warranties or representations regarding the accuracy, completeness, or suitability of the Analysis for any specific purpose. The Analysis is provided “as is,” and we expressly disclaim all warranties, express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose.

6. Changes and Updates

This Disclaimer may be subject to change without notice. Users are encouraged to review it periodically for any updates or modifications. Continued use of the Analysis following changes to this Disclaimer implies acceptance of the revised terms and conditions.

7. Contact Information

If you have any questions, concerns, or require clarification about this Disclaimer or the Analysis presented herein, please seek professional advice or contact us directly at [Contact Information].

This detailed disclaimer provides users with a comprehensive understanding of the limitations, responsibilities, and purpose of the data analysis, emphasizing the importance of independent verification, ethical considerations, and user discretion.

Leave a Reply