\n", " | Booking_ID | \n", "no_of_adults | \n", "no_of_children | \n", "no_of_weekend_nights | \n", "no_of_week_nights | \n", "type_of_meal_plan | \n", "required_car_parking_space | \n", "room_type_reserved | \n", "lead_time | \n", "arrival_year | \n", "arrival_month | \n", "arrival_date | \n", "market_segment_type | \n", "repeated_guest | \n", "no_of_previous_cancellations | \n", "no_of_previous_bookings_not_canceled | \n", "avg_price_per_room | \n", "no_of_special_requests | \n", "booking_status | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30392 | \n", "INN30393 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "Not Selected | \n", "0 | \n", "Room_Type 1 | \n", "53 | \n", "2018 | \n", "9 | \n", "11 | \n", "Online | \n", "0 | \n", "0 | \n", "0 | \n", "94.32 | \n", "0 | \n", "Not_Canceled | \n", "
6685 | \n", "INN06686 | \n", "2 | \n", "0 | \n", "1 | \n", "2 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 1 | \n", "63 | \n", "2018 | \n", "4 | \n", "22 | \n", "Online | \n", "0 | \n", "0 | \n", "0 | \n", "105.30 | \n", "1 | \n", "Canceled | \n", "
8369 | \n", "INN08370 | \n", "2 | \n", "0 | \n", "2 | \n", "3 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 4 | \n", "55 | \n", "2018 | \n", "9 | \n", "11 | \n", "Online | \n", "0 | \n", "0 | \n", "0 | \n", "106.24 | \n", "0 | \n", "Not_Canceled | \n", "
2055 | \n", "INN02056 | \n", "2 | \n", "0 | \n", "0 | \n", "2 | \n", "Not Selected | \n", "0 | \n", "Room_Type 1 | \n", "53 | \n", "2017 | \n", "12 | \n", "29 | \n", "Online | \n", "0 | \n", "0 | \n", "0 | \n", "81.00 | \n", "1 | \n", "Not_Canceled | \n", "
10969 | \n", "INN10970 | \n", "1 | \n", "0 | \n", "2 | \n", "4 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 1 | \n", "245 | \n", "2018 | \n", "7 | \n", "6 | \n", "Offline | \n", "0 | \n", "0 | \n", "0 | \n", "110.00 | \n", "0 | \n", "Canceled | \n", "
24881 | \n", "INN24882 | \n", "2 | \n", "0 | \n", "3 | \n", "7 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 2 | \n", "231 | \n", "2018 | \n", "8 | \n", "1 | \n", "Online | \n", "0 | \n", "0 | \n", "0 | \n", "81.82 | \n", "2 | \n", "Canceled | \n", "
28658 | \n", "INN28659 | \n", "2 | \n", "0 | \n", "0 | \n", "3 | \n", "Meal Plan 2 | \n", "0 | \n", "Room_Type 1 | \n", "71 | \n", "2018 | \n", "5 | \n", "10 | \n", "Offline | \n", "0 | \n", "0 | \n", "0 | \n", "126.00 | \n", "1 | \n", "Not_Canceled | \n", "
20853 | \n", "INN20854 | \n", "2 | \n", "0 | \n", "1 | \n", "2 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 1 | \n", "66 | \n", "2017 | \n", "10 | \n", "9 | \n", "Offline | \n", "0 | \n", "0 | \n", "0 | \n", "75.00 | \n", "0 | \n", "Canceled | \n", "
8501 | \n", "INN08502 | \n", "2 | \n", "0 | \n", "0 | \n", "3 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 2 | \n", "40 | \n", "2018 | \n", "1 | \n", "14 | \n", "Online | \n", "0 | \n", "0 | \n", "0 | \n", "77.55 | \n", "1 | \n", "Not_Canceled | \n", "
1942 | \n", "INN01943 | \n", "2 | \n", "0 | \n", "0 | \n", "2 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 1 | \n", "63 | \n", "2018 | \n", "8 | \n", "9 | \n", "Online | \n", "0 | \n", "0 | \n", "0 | \n", "144.90 | \n", "2 | \n", "Not_Canceled | \n", "
\n", " | count | \n", "unique | \n", "top | \n", "freq | \n", "
---|---|---|---|---|
Booking_ID | \n", "36275 | \n", "36275 | \n", "INN00001 | \n", "1 | \n", "
type_of_meal_plan | \n", "36275 | \n", "4 | \n", "Meal Plan 1 | \n", "27835 | \n", "
room_type_reserved | \n", "36275 | \n", "7 | \n", "Room_Type 1 | \n", "28130 | \n", "
market_segment_type | \n", "36275 | \n", "5 | \n", "Online | \n", "23214 | \n", "
booking_status | \n", "36275 | \n", "2 | \n", "Not_Canceled | \n", "24390 | \n", "
\n", " | count | \n", "mean | \n", "std | \n", "min | \n", "25% | \n", "50% | \n", "75% | \n", "max | \n", "
---|---|---|---|---|---|---|---|---|
no_of_adults | \n", "36275.0 | \n", "1.844962 | \n", "0.518715 | \n", "0.0 | \n", "2.0 | \n", "2.00 | \n", "2.0 | \n", "4.0 | \n", "
no_of_children | \n", "36275.0 | \n", "0.105279 | \n", "0.402648 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "10.0 | \n", "
no_of_weekend_nights | \n", "36275.0 | \n", "0.810724 | \n", "0.870644 | \n", "0.0 | \n", "0.0 | \n", "1.00 | \n", "2.0 | \n", "7.0 | \n", "
no_of_week_nights | \n", "36275.0 | \n", "2.204300 | \n", "1.410905 | \n", "0.0 | \n", "1.0 | \n", "2.00 | \n", "3.0 | \n", "17.0 | \n", "
required_car_parking_space | \n", "36275.0 | \n", "0.030986 | \n", "0.173281 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "1.0 | \n", "
lead_time | \n", "36275.0 | \n", "85.232557 | \n", "85.930817 | \n", "0.0 | \n", "17.0 | \n", "57.00 | \n", "126.0 | \n", "443.0 | \n", "
arrival_year | \n", "36275.0 | \n", "2017.820427 | \n", "0.383836 | \n", "2017.0 | \n", "2018.0 | \n", "2018.00 | \n", "2018.0 | \n", "2018.0 | \n", "
arrival_month | \n", "36275.0 | \n", "7.423653 | \n", "3.069894 | \n", "1.0 | \n", "5.0 | \n", "8.00 | \n", "10.0 | \n", "12.0 | \n", "
arrival_date | \n", "36275.0 | \n", "15.596995 | \n", "8.740447 | \n", "1.0 | \n", "8.0 | \n", "16.00 | \n", "23.0 | \n", "31.0 | \n", "
repeated_guest | \n", "36275.0 | \n", "0.025637 | \n", "0.158053 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "1.0 | \n", "
no_of_previous_cancellations | \n", "36275.0 | \n", "0.023349 | \n", "0.368331 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "13.0 | \n", "
no_of_previous_bookings_not_canceled | \n", "36275.0 | \n", "0.153411 | \n", "1.754171 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "58.0 | \n", "
avg_price_per_room | \n", "36275.0 | \n", "103.423539 | \n", "35.089424 | \n", "0.0 | \n", "80.3 | \n", "99.45 | \n", "120.0 | \n", "540.0 | \n", "
no_of_special_requests | \n", "36275.0 | \n", "0.619655 | \n", "0.786236 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "1.0 | \n", "5.0 | \n", "
\n", " | Booking_ID | \n", "no_of_adults | \n", "no_of_children | \n", "no_of_weekend_nights | \n", "no_of_week_nights | \n", "type_of_meal_plan | \n", "required_car_parking_space | \n", "room_type_reserved | \n", "lead_time | \n", "arrival_year | \n", "arrival_month | \n", "arrival_date | \n", "market_segment_type | \n", "repeated_guest | \n", "no_of_previous_cancellations | \n", "no_of_previous_bookings_not_canceled | \n", "avg_price_per_room | \n", "no_of_special_requests | \n", "booking_status | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33114 | \n", "INN33115 | \n", "2 | \n", "0 | \n", "0 | \n", "1 | \n", "Meal Plan 1 | \n", "0 | \n", "Room_Type 1 | \n", "35 | \n", "2018 | \n", "3 | \n", "25 | \n", "Offline | \n", "0 | \n", "0 | \n", "0 | \n", "540.0 | \n", "0 | \n", "Canceled | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.787730 | \n", "
Precision | \n", "0.722570 | \n", "
Recall | \n", "0.571377 | \n", "
F1 | \n", "0.638140 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.761997 | \n", "
Precision | \n", "0.609766 | \n", "
Recall | \n", "0.759503 | \n", "
F1 | \n", "0.676447 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.767478 | \n", "
Precision | \n", "0.615402 | \n", "
Recall | \n", "0.773930 | \n", "
F1 | \n", "0.685622 | \n", "
\n", " | Recall Score | \n", "F1 Score | \n", "
---|---|---|
Logit: Threshold=0.5 | \n", "0.58080 | \n", "0.645393 | \n", "
Logit: Threshold=0.32 | \n", "0.77393 | \n", "0.685622 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.994268 | \n", "
Precision | \n", "0.996342 | \n", "
Recall | \n", "0.986123 | \n", "
F1 | \n", "0.991206 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.868290 | \n", "
Precision | \n", "0.793370 | \n", "
Recall | \n", "0.808559 | \n", "
F1 | \n", "0.800892 | \n", "
\n", " | Recall Score | \n", "F1 Score | \n", "
---|---|---|
Logit: Threshold=0.5 | \n", "0.580800 | \n", "0.645393 | \n", "
Logit: Threshold=0.32 | \n", "0.773930 | \n", "0.685622 | \n", "
Original Tree | \n", "0.808559 | \n", "0.800892 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.827654 | \n", "
Precision | \n", "0.759619 | \n", "
Recall | \n", "0.693254 | \n", "
F1 | \n", "0.724921 | \n", "
\n", " | Recall Score | \n", "F1 Score | \n", "
---|---|---|
Logit: Threshold=0.5 | \n", "0.580800 | \n", "0.645393 | \n", "
Logit: Threshold=0.32 | \n", "0.773930 | \n", "0.685622 | \n", "
Original Tree | \n", "0.808559 | \n", "0.800892 | \n", "
Depth=4 Tree | \n", "0.706363 | \n", "0.730528 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.844968 | \n", "
Precision | \n", "0.756433 | \n", "
Recall | \n", "0.776879 | \n", "
F1 | \n", "0.766520 | \n", "
\n", " | Recall Score | \n", "F1 Score | \n", "
---|---|---|
Logit: Threshold=0.5 | \n", "0.580800 | \n", "0.645393 | \n", "
Logit: Threshold=0.32 | \n", "0.773930 | \n", "0.685622 | \n", "
Original Tree | \n", "0.808559 | \n", "0.800892 | \n", "
Depth=4 Tree | \n", "0.706363 | \n", "0.730528 | \n", "
GridSearchCV | \n", "0.780968 | \n", "0.766298 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.868474 | \n", "
Precision | \n", "0.792837 | \n", "
Recall | \n", "0.810248 | \n", "
F1 | \n", "0.801448 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.776241 | \n", "
Precision | \n", "0.628539 | \n", "
Recall | \n", "0.775056 | \n", "
F1 | \n", "0.694150 | \n", "
\n", " | Recall Score | \n", "F1 Score | \n", "
---|---|---|
Logit: Threshold=0.5 | \n", "0.580800 | \n", "0.645393 | \n", "
Logit: Threshold=0.32 | \n", "0.773930 | \n", "0.685622 | \n", "
Original Tree | \n", "0.808559 | \n", "0.800892 | \n", "
Depth=4 Tree | \n", "0.706363 | \n", "0.730528 | \n", "
GridSearchCV | \n", "0.780968 | \n", "0.766298 | \n", "
ccp quasi-optimal recall | \n", "0.775056 | \n", "0.694150 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.832595 | \n", "
Precision | \n", "0.780977 | \n", "
Recall | \n", "0.679617 | \n", "
F1 | \n", "0.726780 | \n", "
\n", " | Recall Score | \n", "F1 Score | \n", "
---|---|---|
Logit: Threshold=0.5 | \n", "0.580800 | \n", "0.645393 | \n", "
Logit: Threshold=0.32 | \n", "0.773930 | \n", "0.685622 | \n", "
Original Tree | \n", "0.808559 | \n", "0.800892 | \n", "
Depth=4 Tree | \n", "0.706363 | \n", "0.730528 | \n", "
GridSearchCV | \n", "0.780968 | \n", "0.766298 | \n", "
ccp quasi-optimal recall | \n", "0.775056 | \n", "0.694150 | \n", "
ccp quasi-optimal f1 | \n", "0.679617 | \n", "0.726780 | \n", "
\n", " | Scores | \n", "
---|---|
Accuracy | \n", "0.843940 | \n", "
Precision | \n", "0.752169 | \n", "
Recall | \n", "0.780968 | \n", "
F1 | \n", "0.766298 | \n", "