It consist of data visualization.
This project aims to understand the standard patterns and tendency of hotel bookings status through the comparision of various booking information between resort hotel and city hotel.
Python 3.8
Jupyter Notebook
Code to run: Hotel Booking Analysis.
Visualization: Hotel Booking Analysis Visualization.
Numpy
Pandas
Seaborn
Matplotlib
Plotly express
- Download the dataset (CSV) manually and upload it into Jupyter. Click:File dataset
- Perform data cleaning and data transforming, to remove NaN columns and rows and fixing incomplete data within dataset.
- Perform exploratory analysis and visualization to understand the demographic of visitors such as visitors types, country, visit date and etc.
From the map above shows the most of the guests are come from Europe countries and Portugal, UK and France have the highest numbers of guests are statying in resort and city hotels. This maybe because the hotels are located in Europe.
Figure above to see the average price per room, depending on its type and the standard deviation.
It can be seen that the price are much more higher in the Resort hotel compare to City hotel during the summer season. However, during spring and autumn the price of city hotel is most expensive.
It clearly shows in the distribution that most of the people do not seem to prefer to stay at the hotel for more than 1 week. However, it seems normal to stay in resort hotels for up to 12-13 days. It is obvious shows that when people go to resort hotels, they prefer to stay longer.
The donut pie above is the meal categories. There is a big difference in the Bed&Breakfast category and the others. Almost 80% of bookings reserved for Bed&Breakfast.
City hotel has higher demand during spring and autumn, and the prices are highest as well. When the prices are highest from June to September, the demand for Resort hotel are slighty go down.¶ Resort hotel and City hotel have the lower demanded during winter.
Bar chart above indicated that most of the people prefer to stay for around 3 to 4 nights in city hotel.
It can be seen that guests from Aviation Segment not likely to stay at the hotels or likely stay shortly due to business.
In the table above, we can see that large numbers of cancelation from City Hotel compare to Resort Hotel.
There are highest cancelations for Resort and City hotel during summer and lowest during winter.
We can see that high numbers of bookings are from europe, this may due to european has more holiday vacation. The price are much more higher in the Resort hotel compare to City hotel during the summer season, while the price of city hotel most expensive during spring and autumn. Most of the people do not seem to prefer to stay at the hotel for more than 1 week. However, it seems normal to stay in resort hotels for up to 12-13 days. It is obvious shows that when people go to resort hotels, they prefer to stay long. City hotel has higher demand during spring and autumn, and the prices are highest as well. When the prices are highest from June to September, the demand for Resort hotel are slighty go down. Also, Resort hotel and City hotel have the lower demanded during winter. There are highest cancelations for Resort and City hotel during summer and lowest during winter.