Airbnb seattle9/23/2023 Phew~ Supply and demand - guest group configurationĪs an Airbnb host, I would also like to know the common group size of Seattle visitors. Listings with less than 2 bedrooms are well sought after.īut wait! Properties with no bedrooms, what are kind of properties are these?Īnd the number of beds in these properties?Īll of these properties which no bedrooms are renting the entire apartment, and they do provide at least one bed. Find out the ratio between the number of listings (supply) to the number of bookings (demand) of different bedroom configurations: Supply and demand - bedroom configurationsĪs an Airbnb host, it will be good to know if my property is oversaturated in the market. Minimum nights and estimated revenue are not highly correlated But after removing that host, minimum nights and estimated revenue are not highly correlated, a correlation of 20% between minimum nights and revenue. Host with 1000 minimum nights has caused a bais towards higher minimum nights resulted in higher revenue, with a correlation of 87% between minimum nights and revenue. Let’s look at the correlation between minimum nights and estimated revenue.Īnd the correlation between minimum nights and estimated revenue after removing the listing with 1000 minimum nights. These are the top hosts (up to 4 minimum nights) with the highest estimated revenue.įrom these 2 tables, longer minimum nights results in higher revenue. These are the top hosts (up to 7 minimum nights) with the highest estimated revenue. Most hosts have minimum nights of up to a month, the host with 1000 nights, gotta filter it away. ![]() But it might be data anomaly because 1000 nights are kind of extreme, so let’s look at the proportion of listings with different minimum_nights. Wow! Looks like our top earners are hosts have minimum nights of 1000. These are the top 5 listings with the highest estimated revenue: July, August and September are the best periods to maximise revenue. From October to December is a good time to take a break and enjoy the holidays if they want to. Months before May are the best time for maintenance work. We still can’t use it for analysis as it is not a numerical value, so we remove the dollar symbol and convert the values as numeric values: The column price, which is the price of the listing, it contains the dollar sign ($). There are missing values in reviews rating columns (review_scores_rating, review_scores_accuracy, review_scores_cleanliness, review_scores_checkin, review_scores_communication, review_scores_location, - review_scores_value) there are missing values in columns bathrooms, bedrooms, and beds.values in the price column contain the dollar symbol ($).there are 3813 listings in this dataset.Let us look at what the first 10 rows looks like with pd_listings.head(10):Īnd examine the summary of the numerical data with pd_scribe(): Our data will be loaded in pandas, comma-separated values (CSV) files can be easily loaded into DataFrame with the read_csv function. In this article, I will perform exploratory data analysis on the Airbnb dataset gotten from Inside Airbnb. do hosts with higher rating have higher revenue?. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |