AIRBNB NEW YORK LISTINGS AND REVIEW ANALYSIS

Airbnb Newyork published data for year 2019 deplicting about 49k listings that includes information about price, host, neighbourhood, room type, as well as over 1m reviews received from guests in 5 boroughs. This dashboard analyzes the prices and reviews of Airbnb listings in New york for 2019.##

In this project, I use python to analyze Airbnb listings as a qualitative and quantitative data and Tableau to visualize Airbnb New York listings and review

Python Code: https://github.com/ellaclauz/Airbnb-NYC-2019/blob/main/Airbnb_NYC_2019.ipynb

TAKEAWAYS

1. Among the 5 Boroughs of New York, Manhattan which is geographically the smallest and is the most densely populated, generates the highest revenue of over $792m for Airbnb in 2019.

2. 51.97% of listings are Room Type Entire Home/Apartment (whole place to themselves including private entrance and no shared spaces). Entire Home is the most popular among Airbnb guests followed by Private Room. Also, majority of the listings are listed as Entire Room and Private Room.

3. Sonder(NYC) is the host with 327 listings, which is the highest of listing owned by one person in New York.

4. From this visualization, we can see that reviews of borough per month do not affect the average price of a listing.

5. Investing in Manhattan is recommended since it is a high-demand area and it's average nightly cost for all room types are higher, which can return higher profits.

Here is the link to the dashboard: https://public.tableau.com/app/profile/ekoh.stella/viz/AirbnbNewYorkListingsandReviewAnalysis/Dashboard2