Insights from NYC Real Estate Datasets and APIs

PropTech Challenge aims to inspire innovative solutions solving real-world challenges faced by today’s leading real estate companies. The project hence explores potential uses of Blockchain Technology across all facets of the real estate industry, including property databases. Advantages of analyzing dataset [NYC Property Sales] include clean visualization of data and building a model to predict housing prices in New York.

Key Analysis Drawn

• 20% of all Sale Prices are NULL.
• There are ZIP CODES with a value of 0, which is probably wrong.
• 75% of properties have no COMMERCIAL UNITS.
• At least 50% of all properties have only 1 TOTAL UNIT. I am not quite sure what to make of that yet.
• There are properties have 0 SQUARE FEET, which shouldn't be possible unless they don't exist yet or the data is wrong.
• Some buildings were built in the YEAR 0, which again is wrong.
• Some properties have a SALE PRICE of 0, which is also wrong or a transfer but not actually a sale.
• Property needs to be more expensive than 100,000 USD.
• Property needs to be cheaper than 5,000,000 USD.
• Normalizing the Sale Prices