US Real Estate Data Project

About the Dataset

This dataset contains Real Estate listings in the US broken by State and zip code. Data was collected via web scraping using python libraries by the author - Ahmed Shahriar Sakib. 

The data set was updated one month ago. 

Content 

The data set has 1 CSV file with 12 columns: status, price, bed, bath, acre_lot, full_address, street, city, state, zip_code, house_size, and sold_date

Acknowledgments

Data was scraped from www.realtor.com, A real estate listing website operated by the News Corp subsidiary Move, Inc. and based in Santa Clara, California. It is the second most visited real estate listing website in the United States as of 2021, with over 100 million monthly active users. 

Questions we can ask before planning this project: 

Can we predict housing prices based on this data? 

Which location contains the house with the highest prices? 

What is the correlation between house prices and other attributes? 

What could be the trend behind housing prices? 

Project: 

Step 1. Import all the packages. 

Step 4. Sort and filter the data, dropped any duplicated, Null, or NA rows, and changed the unwanted data type into the one I need. For detailed coding, please check here

Step 5. Analysis 

Find the relationship between the number of listings and states in the US 

Find the trends of prices along with the year: 

Find the relationship between Price and the number of bedrooms

Find the relationship between Price and states in the US: 

Find the correlations between price and other factor of the data: 

For detailed coding and visualization, please check my GitHub portfolio page by clicking here

Conclusion

    

            1. House prices fluctuated from 1980 to 2020, and the entire trend is going upward. 

            2. House prices are determined by many factors, such as the number of bedrooms and house size. 

            3. New York is still the top real estate market in the United States. New Jersey, Connecticut, and Massachusetts have shown higher growth than the other states. 

Thank you for watching my project. Your feedback and comments are appreciated.