Calculated the average hotel stay and counted the number of hotel reservation IDs for all hotel reservations that were not canceled and at least one day in length.
Data Source: Data modified from the original source (https://www.kaggle.com/jessemostipak/hotel-booking-demand)