Boston Airbnb price Analysis

Write a Data Science Blog (Udacity Nanodegree Program)

Yoshitaka Kawano
5 min readFeb 1, 2021

This blog is Udacity Nanodegree Program of Data Scientists.Related code is here[https://github.com/kawano8811/Write-A-Data-Science-Blog-Post].

Introduction to Boston Data

Airbnb’s room pricing data for Boston is now available on Kaggle. There is data on daily price changes and the number of beds in each room.

This blog will provide an analysis of prices in Boston.

When I plotted the time series data, I noticed something interesting. The price goes up at certain times of the year. So I analyzed it.

Question 1: Is there a seasonality to prices?

And when are they most expensive?

Boston Price Calendar

Let’s take a look at the day-to-day changes in the mean price of Boston

Observation of Boston Price

  • Prices are dropping rapidly over 2017–01.
  • After that, there is a slow upward trend.
  • But, there are price peak around 2017–04–15~2017–04–17.
  • And, periodic small peaks are observed.

About periodic peaks.

About periodic peaks.

It’s a weekly period of Friday and Saturday.
It seems natural that weekend room rates would go up.

What is the big peak at 2017–04

I googled to see if there were any major events in Boston in April 2017.
Then I found Boston Marathon was held at April 17.
May be it’s a cause of price peak of 2017–04–14 to 2017–04–16.

Question 2: What rooms raised their prices during the event?

I’ve found that prices go up depending on the event.
I wonder if all the rooms will have their prices increased, or just some of them.

Mean price of listing and during event

The price outside the event is about $170, and during the event it is about $240, an increase of about $70.

Distribution of the price

Looking at the distribution, it appears that there is more data with higher prices during the event, but the clear difference is not clear.

Check the quartile

Let’s take a look at the prices for each quartile range of price.If the rooms at the top of the price range have increased in price significantly, then the difference between the graphs should be larger on the right side.

If the rooms at the top of the price range have increased in price significantly, then the difference between the graphs should be larger on the right side.

This suggests that the high-priced rooms raised their prices during the event.

Price changes lower 50% and top 25%

This suggests that the high-priced rooms raised their prices during the event.

I’ve noticed that the top priced rooms have had their prices raised significantly from the original price.

Question2 Conclusion

The price spike due to the event was in rooms with listing prices as high as $200 or more.

Question 3:The price spike due to the event was in rooms with listing prices as high as $200 or more.

Property type? num of beds? or other?

Number of beds

There are obviously more beds.

Number of accomodates

It’s too.There are more accomodates.

Top 5 of Property Type

Top 3 are same, Apartment, House and Condominium.

Room Type

There are significant difference.
Bottom 25% rooms are mainly occupied by “Private room” but top 25% are “Entire home/apt”.

Question 2 Conclusion

The difference in price was the size of the room.

Top 25% rooms are mainly entire home/apt and have many beds, so it can accommodate a lot of people.

Question 4:What is the difference of Boston and Seattle?

Is there a difference between Boston and Seattle, and if so, what is it?

Number of rooms

Boston is 3,585 and Seattle is 3,818. It’s almost same.

Price

Boston has more rooms over $100.

Show only under $500.

What is the factor of the price

The price difference in Boston was the size of the room.
So what is the reason for the difference between Boston and Seattle?

Room Type

There are no difference between Boston and Seattle.

Number of accomodates

There are no significant difference too.

The size of the room does not seem to be related to the difference in price.
So what is the Factor?

I think the original price of the house may be different.
So I decided to look up the price of the house, but I don’t know how to do that since I am Japanese and don’t live in the US.

Therefore, I thought that if Boston is more urban than Seattle, the price of houses would be higher.

Population and Density of Boston and Seattle

It’s from Wikipedia.

[Boston]https://en.wikipedia.org/wiki/Boston

[Seattle]https://en.wikipedia.org/wiki/Seattle

Population is almost same, but Boston is more densely populated.
So that I think housing prices are higher in Boston.

Question 4 Conclusion

It was not possible to find out the actual housing prices.However, based on population density, Boston is considered to be more urban.Therefore, housing prices in Boston are expected to be higher.

--

--