Let’s take a look of Seattle AirBnB Open Data using Python

Which features are most related to homestay cost? How do seasonal costs change? What is different between superhost and regular host? Let’s get the answers by analyzing the data in python

Photo by MILKOVÍ on Unsplash

Summary

  • listings.csv — including full descriptions and average review score
  • calendar.csv — including listing id and the price and availability for that day
  • reviews.csv — including unique id for each reviewer and detailed comments

How do seasonal costs change?

  1. Average prices are highest in summer and increase slightly in December. Perhaps summer holidays, year-end events, and Christmas were influential.
  2. Prices fluctuate mainly at high price points, and cheap rooms do not change even when the season changes.

Which features are most related to homestay cost?

Correlations related to reviews

  • Number of reviews and price has a little negative correlation. Expensive homestay are expected to no attract many people and have fewer reviews.

Correlations related to bathrooms, accommodates, bedrooms, beds

  • Whether or not a homestay can be rented for a long time has no significant correlation with other features other than each other. The minimum and maximum stay dates are not significantly correlated with other features.

What is different between superhost and regular host?

  1. Superhosts almost slightly outperformed all score of reviews. However, there are far more reviews written. It could be because more customers are staying at accommodation on the superhost, or it could be because the superhost encourages customers to actively write reviews.
  2. Another difference is that on average the superhost has fewer rooms than the rest of the hosts.
  3. Even though the average number of beds, toilets, and number of people in a room operated by superhosts are slightly smaller There is a shorter minimum/maximum period for customers to stay, and more guests can be included. But the difference is not big.

Assuming that the higher the number of reviews, the more customers it attracts, the more likely a superhost will have other factors that can attract more customers. For example, they may have been running a homestay for a long time, or their location may be better.

Date the host started hosting

AirBnB superhost do not requires long hosting period. Host can become a superhost even if hosting period is less than 12 months. Hosting for a long time doesn’t mean host will become a superhost.

Location differences between superhosts and regular hosts

It can be seen that there is not a big difference in location.

(FIXED — My analysis on this point was performed incorrectly, So I wrote there is a lot of differences so modified the article..… really sorry… 😢 🙏🙏🙏🙏🙏🙏)

Conclusion

  1. The size of the accommodation has a big impact on the price. Price and number of reviews have a weak negative correlation.
  2. The biggest distinction between the superhost and the rest is the number of reviews. The rating is slightly higher than the rest, but it is about the same level.

2020.12.8 ~ 2022.6.7 육군복무중 Serving in the South Korean Military Service