#capstone project #Capstone Project Submission #hotel booking analysis #EDA for Alma Better
Team Member’s Name, Email and Contribution: Purushotam [email protected] Highly committed coordinated team work for successful completion of the project.
Please paste the GitHub Repo link.
GitHub Link: - https://github.com/datascientistpurushotam/EDA-Projects/tree/Hotel_Booking_Analysis
Please write a short summary of your Capstone project and its components. Problem Statement Question 1. Which customer type preferred the most resort hotel? Question 2. Which type of hotel refunded the most? Question 3. Which distribution channel is mostly used for booking City hotel? Question 4. Which type of hotel is preferred by customer having children? Question 5. Which type of hotel is most preferred for weekend night? Question 6. Which year has highest booking and cancellation based on market segment (complementary)? Question 7. preferred food by customer based on top 5 country? Question 8. Most favorable month for booking :- Question 9.Which are the top five agents for city hotel? Question 10. Hotel data based on month where repeated guest is 1:
Approach
We have divided the data into three parts
Data collection: -
Dataset will be attach with the project
Data loading: -
Dataset was loaded on google drive was loaded on goggle colab ('content/Hotel Bookings raw.csv’)
Data Cleaning and manipulation: - For data cleaning NumPy, pandas, and matplotlib is used
Removing the duplicates: - Analysing the data we found out of 119390 rows 31994 rows are duplicates so we removed them.
Removing the company column with most nan values: - Analysing the company column we found it has only 5259 values are not nan remaining does not provide any significant data. So, we deleted the column.
Beginning with EDA: -
Conclusion
- Transient types of customers visited to Resort Hotel most.
- City hotel has non refunded the most 845 compared to Resort Hotel having 193.
- TA/TO is most preferred for City Hotel 44549.
- City hotel is more preferred by customers having children with age group as per dataset.
- City hotel is most preferred for weekend nights.
- The out of 2015, 2016, 2017 2016 has the highest booking and cancellation based on complimentary
- BB is most preferred by the Portugal
- August month is most preferred for the booking
- 9.0 is among the top five agents for the City Hotel
- So, March has the most Repeated guest 418
From the above conclusions we can say that City hotels are the most preferred hotel type by the guests. We can say City hotel is the busiest hotel.