The dataset 'rental' is extracted from rental website, it is a daily screenshot of New York City rental market. I will utilize this dataset to visualize and construct models so as to deliver a comprehensive view for newyorkers who is struggling to find their next apartment.

The dataset contains three main boroughs of New York City (exclude Staten Island and Bronx) and their submarkets as well as neighborhoods, displayed by categorical variables. Descriptive numerical metrics are used to show detailed apartment information. Variable 'rent' is dependent variable that will be predicted in models.

This notebook showcases the relationship among multiple features, the factors that impacting rental price, the trend within locational, numerical and categorical variables. By wrangling, visualizing and fully understanding the dataset, predictive modeling for rental price will be deployed in another notebook: New York City Rental Market Predictive Modeling.

Besides exploring and analyzing the dataset, common questions will be answered to consummate data storytelling part.

1. What is the median and rental price range in each borough ?
2. Which submarket and neighborhood do people choose to live ?
3. Do amenity fee, W/D, doorman and elevator really affect rental price regionally ?
4. Do amenity fee, W/D, doorman and elevator have the same impact on rental price no matter what kind of unit it is ?
5. Which submarket has the most available apartments ?
6. Given a budget, where is the largest apartment located ?
7. Given a unit, which is the cheapest apartment ?
8. Given a budget, which apartment has the best view ?
9. Given a budget, which apartment has the most convenient transportation ?
10. Under the same unit, which submarket has the cheapest apartment ?
11. Given a budget, what is the most ideal combination of bedroom and bathroom ?
12. Geographically speaking, which area has the cheapest or most expensive apartments ?
13. Which neighborhood has the highest average rent overall ?
14. Which are the top 5 neighborhoods with the most available apartments ?
15. Which neighborhood has the largest apartment overall ?
16. Which neighborhood has the newest apartment overall ?