Baselight

Hotel Reservations Dataset

Can you predict if customer is going to cancel the reservation ?

@kaggle.ahsan81_hotel_reservations_classification_dataset

Hotel Reservations
@kaggle.ahsan81_hotel_reservations_classification_dataset.hotel_reservations

  • 512 KB
  • 36275 rows
  • 19 columns
booking_id

Booking ID

no_of_adults

No Of Adults

no_of_children

No Of Children

no_of_weekend_nights

No Of Weekend Nights

no_of_week_nights

No Of Week Nights

type_of_meal_plan

Type Of Meal Plan

required_car_parking_space

Required Car Parking Space

room_type_reserved

Room Type Reserved

lead_time

Lead Time

arrival_year

Arrival Year

arrival_month

Arrival Month

arrival_date

Arrival Date

market_segment_type

Market Segment Type

repeated_guest

Repeated Guest

no_of_previous_cancellations

No Of Previous Cancellations

no_of_previous_bookings_not_canceled

No Of Previous Bookings Not Canceled

avg_price_per_room

Avg Price Per Room

no_of_special_requests

No Of Special Requests

booking_status

Booking Status

INN00001212Meal Plan 1Room_Type 12242017102Offline65Not_Canceled
INN00002223Not SelectedRoom_Type 152018116Online106.681Not_Canceled
INN00003121Meal Plan 1Room_Type 112018228Online60Canceled
INN0000422Meal Plan 1Room_Type 12112018520Online100Canceled
INN00005211Not SelectedRoom_Type 1482018411Online94.5Canceled
INN0000622Meal Plan 2Room_Type 13462018913Online1151Canceled
INN00007213Meal Plan 1Room_Type 13420171015Online107.551Not_Canceled
INN00008213Meal Plan 1Room_Type 48320181226Online105.611Not_Canceled
INN0000934Meal Plan 1Room_Type 1121201876Offline96.91Not_Canceled
INN0001025Meal Plan 1Room_Type 44420181018Online133.443Not_Canceled

CREATE TABLE hotel_reservations (
  "booking_id" VARCHAR,
  "no_of_adults" BIGINT,
  "no_of_children" BIGINT,
  "no_of_weekend_nights" BIGINT,
  "no_of_week_nights" BIGINT,
  "type_of_meal_plan" VARCHAR,
  "required_car_parking_space" BIGINT,
  "room_type_reserved" VARCHAR,
  "lead_time" BIGINT,
  "arrival_year" BIGINT,
  "arrival_month" BIGINT,
  "arrival_date" BIGINT,
  "market_segment_type" VARCHAR,
  "repeated_guest" BIGINT,
  "no_of_previous_cancellations" BIGINT,
  "no_of_previous_bookings_not_canceled" BIGINT,
  "avg_price_per_room" DOUBLE,
  "no_of_special_requests" BIGINT,
  "booking_status" VARCHAR
);

Share link

Anyone who has the link will be able to view this.