Booking demand information from 2015 to 2017 of two types of hotels in Portugal was collected. There are over 110k rows of data on total with information such as booking date, number of people for a booking, average daily rate etc.
Jump right to the jupyter notebook to view my project from start to finish.
The hotel bookings demand data set can be found on Kaggle. For more detailed information about the data set visit Science Direct.
The goal in this project is to answer various business questions about these two hotels in Portugal. Based on our findings, we will make recommendations to the owner of these hotels with regards to how they can increase revenue and improve service.
1- How many bookings are made for each month?
2- How often are bookings cancelled?
3- What is the distribution of customer types like?
4- How often are bookings cancelled by each customer type?
5- Are there any meaningful correlations between numerical columns?
6- Where do the guests come from?
7- How much does the daily rate of a booking costs based on the number of guests in that bookings?
8- Which meal plans do the guests prefer?
9- How often are the rooms the guests were assigned the same as the ones they reserved?
- Python: Pandas, Matplotlib, Seaborn
- Jupyter Notebook
- Data Cleaning, Data Visualization, Data Analysis, Statistics
Internal links in jupyter notebook do not work when rendered on Github but they will work if you choose to dowload it on your desktop.