In-Depth Exploratory Data Analysis on Airbnb NYC Listings 2019 Dataset 📊

Objective 🎯

To perform in-depth exploratory data analysis on Airbnb NYC 2019 Dataset

Introduction 🚀

Airbnb is an online marketplace that connects people who want to rent out their homes with people looking for accommodations in that locale. NYC is the most populous city in the United States, and one of the most popular tourism and business places globally. Since 2008, guests and hosts have used Airbnb to expand on traveling possibilities and present a more unique, personalized way of experiencing the world. Nowadays, Airbnb became one of a kind service that is used by the whole world. Data analysts become a crucial factor for the company that provided millions of listings through Airbnb. These listings generate a lot of data that can be analyzed and used for security, business decisions, understanding of customers’ and providers’ behavior on the platform, implementing innovative additional services, guiding marketing initiatives, and much more.

Tools Used 🔨

1. Python 🐍

Dataset 🔤

Download Dataset from here

• Dataset contains 48895 Rows and 16 columns

During this EDA, I addressed the below questions :

1. What are the top 10 host IDs with the highest number of bookings?
2. What are the top 10 host Names with the highest number of bookings?
3. What types of rooms does the host with the highest number of bookings offer, and what is the price range for these rooms?
4. What types of rooms does the host with the second highest number of bookings offer, and what is the price range for these rooms?
5. Which Neighbourhood group has the highest number of bookings?
6. Which Neighbourhood Group has the maximum price range for rooms?
7. What are the Top 10 Neighbourhoods having highest number of bookings?
8. Which room type has highest number of bookings?
9. What is the Average price for each room type?
10. What are the average of minimum nights for different room types?
11. What are the top 10 number of days on which highest number of bookings were done?
12. What is the average number of reviews for each room type?
13. Which Neighbourhood group got the highest number of reviews?

Conclusion 🙂

• The first Host ID from the top 10 host id's has 327 bookings constitutes to 66.8% of Total bookings
• The host named Michael has 417 bookings attributed to him, accounting for 85% of the total bookings, followed by David with the total bookings of 403.
• Michael, the host with the highest number of bookings, offers all room types, including Private rooms, Entire home/apts, and Shared rooms. Specifically, he has 251 Entire home/apts, 152 private rooms, and 14 Shared rooms. The price range for these accommodations is between 25 and 1700 dollars.
• David, the host with the second-highest number of bookings, provides all types of rooms, including Private rooms, Entire home/apts, and Shared rooms. Specifically, he offers 214 Entire home/apts, 184 private rooms, and 5 Shared rooms. The price range for these accommodations falls between $25 and $2000.
• An observation reveals that among all the neighborhood groups, the Manhattan group has the highest number of bookings, totaling 21,661, which constitutes 44.3% of all bookings across all groups, followed by Brooklyn which ranks as the second-highest neighborhood group with a total of 20,104 bookings, covering 41% of all bookings.Staten Island is the neighbourhood group with the least number of bookings which constitutes only 0.76% of all the bookings.'
• Observation says that Manhattan has the highest range of prices for the listings with 150 price as median observation, followed by Brooklyn with 90 per night.
• Bronx Neighbourhood is the cheapest among all the neighbourhoods.
• The Williamsburg neighborhood has the highest number of bookings, totaling 3,920, which constitutes 80% of all bookings.
• Entire home/apt has the highest number of bookings, accounting for 52% of the total bookings, with a total of 25,409 bookings. Private room follows closely behind with a total of 22,326 bookings, covering 46% of the total bookings. Shared rooms have the least number of bookings.
• Surprisingly, Private rooms got more reviews than Entire Home/apt.
• The Manhattan neighborhood group received the highest number of reviews, followed by Brooklyn with a total of 20,104 reviews.