knnithin02/hotel-booking-cancellation-analysis ? reverse-engineered prompt

Build me a hotel booking cancellation analysis project that explores why reservations get cancelled for a City Hotel and a Resort Hotel.

I want a notebook that loads the hotel bookings data, cleans it, and then shows the main patterns behind cancellations, especially things like price, lead time, booking channel, country, and month. Please include clear charts and simple explanations for each finding so someone non technical can understand what is going on. I also want a short written report style summary with the key takeaways and a few practical business recommendations to help reduce lost revenue.

Make sure it compares cancelled bookings with kept bookings, highlights the most important trends, and calls out any seasonal patterns. If needed, look up current docs online for plotting or notebook formatting, but keep the focus on the analysis and the story from the data. The final result should feel like a polished exploratory analysis that I could present to a hotel team.