Seattle is a seaport city on the West Coast of the United States. The city is situated on an isthmus between Puget Sound and Lake Washington and has a noteworthy history. Meanwhile, this city has robust economy. In July 2013, it was the fastest-growing major city in the United States and remained in the Top 5 in May 2015 with an annual growth rate of 2.1%. In July 2016, Seattle was again the fastest-growing major U.S. city, with a 3.1% annual growth rate. Despite eye-catching economic performance, the tourism is also very attractive. Seattle international Film Festival, Northwest Folklife over the Memorial Day weekend and numerous Seafair events throughout July and August, attracted 100,000 people to attend.
If you were the citizen of Seattle, and just having an vacant house, how would you dispose your house to earn money? Renting your house is a good choice to earn money without any risk. Before loading the house information to AirBNB, you may need to make a survey. Which month is the peak tourist season? The comments about accommodation given by guests are positive or negative? What’s the distribution of neighbourhood’ s price? Can I predict the price of my house in the future times? Fortunately, AriBNB company published the two years of Seattle homes data, so you can use this data to make a survey. Let’s do it!
Question 1: which month is the peak tourist month?
We add the total prices grouped by month. As we can see the picture, the gross amount of July is the hightest, and the trend is growing from January to July. The climate is one of the reason, autumn, winter and early spring are frequently characterized by rain in Seattle. The other reason is the festival, there are a lot of annual fair and festivals in summer, so summer can earn a lot of money by rent out.
Question 2: the comments about accommodation made by guests are positive or negative:
Wordcloud is a very vivid picture to express which words having highest frequency in the comments. We use wordcloud package in python to plot figure. Unsurprisingly, the most of the visitors have a good impression on accommodation, and they have a good time when they lived the rent house. So you have a lot of chances to rent your house to visitors.
Question3: what is the distribution of neighbourhood’s prices?
We have 81 neighbourhoods in the dataset, the distribution as follows, one house in the Fairmount Park has the hightest rent price, the second is Portage Bay and Industrial District. The mean price of the rent is $127.98.
Discussion:
We came up with a few easy questions about the dataset, and try to answer it using basic statistical graph. What I want to mention in the end is we can also predict the rental price in the future time using machine learning. From what has been discussed above, I think you may have different ideas about the dataset and have desire to prove it , what are you waiting for , hurry it up!
