Goal: To understand the differences between hosts with different numbers of properties.
How do the room type, the number of reviews and the number of hosts affect property prices?
What is the relationship between the number of reviews, price, number of hosts and rating in hotel rooms?
How does the availability of properties relate to the average number of hosts across different room types and neighborhoods?
What is the relationship between the number of reviews, room type, average price, and number of hosts in specific neighborhood?
How does the number of bathrooms affect the availability and prices of the properties?
Conclusions:
A property of type room 'private room', which has no reviews, and its number of hosts is 1: the minimum price for this property is 19 $, the maximum price for this property is 1056 $, and the average price is 85.77 $.
A customer interested in a hotel room type with the maximum number of reviews (885), the maximum price will be 159 $, the number of hosts will be 23, and the rating will be 4.51.
There are 449 properties whose availability is 0 with an average host of 2.92, there are the most properties of the room type 'Entire home/apt' (4,274) with an average host of 11.12 and the neighborhood with the highest number of properties (626) is 'West Town' with an average of hosts of 6.5.
A customer interested in the property with 2 reviews and the room type is 'private room',
the lowest average price is $18.5, with an average of 14 hosts and the property's neighborhood is 'South Chicago'.
The maximum number of properties (3,635) contain only one bath, and the minimum number of properties (1) contain 9.5 or 11 baths in a property.