Finding the perfect neighborhood to buy a house can be exhausting especially if a family is moving to a new area and cannot distinguish one enclave from another.Rising home prices are often seen as one of the biggest markers of a good neighborhood. However, there are also other factors involved, such as school ratings and good city services, that have a greater impact on the lifestyle of a neighborhood. In service to homebuyers as well as the real estate agents of the New York City, that makes use of publicly available datasets such as GreatSchools school ratings, 311 service request, and Annualized Property Sales in order to provide them with highly relevant, but hard to access, analysis on the neighborhoods.

The outcome of this analysis is an interactive map of New York City giving insights on various aspects a home buyer/seller would look for. It also helps in determining if houses are overpriced or underpriced based on the features of the neighborhood. With this analysis, a potential home buyer or real estate agent would be able to get an extensive picture of the neighborhood under consideration before making a final decision.

DATA

3 public datasets were used in this analytics.

A) GreatSchools School Ratings

The dataset contains school ratings of all public schools in NYC. The dataset was < 1 MB and provided valuable insights on various public schools in each neighborhood.

**Link to the dataset: **https://www.greatschools.org

B) 311 Service Requests from 2010 to Present

The 311 dataset contains information about all the 311 service requests made in NYC since 2010. Service Requests created in the year 2019 were chosen since they would be the most relevant to the current state of the neighborhood.

**Link to the dataset: **https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/7ahn-ypff

C) NYC Citywide Annualized Calendar Sales

This dataset contains sales information on properties sold in New York city between 2016 to 2020. It has information not only on houses sold in NYC but also on commercial buildings, religious buildings and warehouses. Our analysis will be concerned only with the price of one family dwellings.

**Link to the dataset: **https://data.cityofnewyork.us/City-Government/NYC-Citywide-Annualized-Calendar-Sales-Update/w2pb-icbu

#hadoop #python #spark #nyc #data-science