Welcome to Seattle!
Since 2008, guests and hosts have used Airbnb to travel in a more unique, personalized way.
As part of the Airbnb Inside initiative, this dataset describes the listing activity of
homestays in Seattle, WA.
Do you know?
Can you describe the vibe of each Seattle neighborhood using listing descriptions?
What are the Seattle’s rent price? and what aspects affect the house prices?
What are the busiest times of the year to visit Seattle?
Now we get a year of Seattle house rend records offered by Airbnb. Let us have a glance!
There are many seattle neighbourhoods overview, we collect them and count all the key
words. Then we get some interesting info.
Is it boring? We do some sorting on them, ‘downtown’,’center’,’restaurant’ belong to living,
‘grocery’,’shops’,’market’,’blocks’ belong to shoping, ‘coffee’,’bars’,’food’ belong to catering,
‘hill’,’park’,’lake’,’beach’ belong to leisure, and ‘museum’,’art’ belong to culture.
Then we count them again, and we draw a line diagram.
Now it looks better. We can say some Seattle neighborhoods’s feature, Queen Anne and Downtown are
good at living and shopping, museum art. Seward park, Lake City, Cascade are good at leisure.
Capitol Hill and Beacon Hill are good at catering. Also, there are some remarkable features are
shown in data table’s value, such as space needle,university, West Seattle’s beach, Cascade’s lake,
Capitol Hill’s bars, Ballard’s restaurants etc, their count value are most high.How about Seattle rent price’s influencing factors? We have to get answer from data.
After a long time’s data clean, we remove the empty numbers, fill in some mean value, get rid of
useless data, and use machine learning model to training the data.
Don’t panic. From this illustration, we just want to say that the influence factors of price are many.
We choose the most important ones.
Through PCA analysis, we can get 4 kinds of positive facts:
- “Hair Dryer”, Iron, Hangers, “24-Hour Check-in”
- “Elevator in Building”, Downtown, Gym
- bedrooms, accommodates, beds, bathrooms
- availability days at 90, 60, 30 .
and private house property， pet living in property， some review scores are negative facts.
In my opinion, the house’s clean and tidy, no negative comments are important.
Last but not least.We get an average house price for the whole year.
From the above mean price line graphs, we can see the busiest season of Seattle in a year is around summer
the price keeps going from January(average price:122 usd) reached to the peak on July (average price:152 usd).
The mean of the listing price increased by 24.9% compared the start of the year.
Thanks a lot!